Arkadiusz Łukasiewicz questions

Arkadiusz Łukasiewicz answers

• how to get value of column from sys_refcursor returned by a function being called
• Represent a list of elements in XSD
• Oracle- Split string comma delimited (string contains spaces and consecutive commas)
• how to execute the procedure one after another in oracle sql developer using chains?
• What is the use of SESSIONTIMEZONE and DBTIMEZONE in oracle
• How to count consecutive duplicates in a table?
• Retrieve large clob data using sqlplus
• Insert BLOB test string bigger than 2000 or 4000 bytes
• How to make dbms_metadata.get_ddl more pretty/useful
• Simulate a scenario where message goes into exception queue