IntegrationTest/sql/show_db.sql

0001 /* Show all the database objects */
0002
0003 SELECT table_name FROM user_tables ORDER BY table_name;
0004 SELECT sequence_name FROM user_sequences ORDER BY sequence_name;
0005 SELECT procedure_name, object_name FROM user_procedures ORDER BY procedure_name;
0006 SELECT object_name AS FUNCTION FROM user_objects WHERE object_type = 'FUNCTION';
0007 SELECT trigger_name, table_name FROM user_triggers WHERE trigger_name NOT LIKE 'BIN%' ORDER BY trigger_name;
0008 SELECT db_link, username FROM user_db_links;