doT.sYs

February 24, 2009

Oracle - Tips (add’l)

Filed under: Oracle, Database

You can select list of tables from all the different schemas in your oracle database, here’s how 

SELECT all_tables FROM all_tab_columns;

or get all the table details 

SELECT * FROM all_tab_columns;


Blog Redesigned by Karen Eve R. Eso