Oracle snippets

oraclesnips.md

Oracle Snippets

Comma separated string as list

SELECT REGEXP_SUBSTR(<here your string>, '[^,]+', 1, LEVEL) AS registro
  FROM DUAL
CONNECT BY REGEXP_SUBSTR(<here your string>, '[^,]+', 1, LEVEL) IS NOT NULL

List all objects created in database

SELECT owner, object_name, object_type
FROM all_objects
ORDER BY owner, object_type, object_name;