Arkadiusz Łukasiewicz questions

Arkadiusz Łukasiewicz answers

• Search a string for a regular expression pattern and replace each occurences as a derivation of itself in oracle SQL
• Partially consuming a cursor in multiple pl/sql calls without defining it in package spec
• 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