EcalCondDB/sql/show_db.sql

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