Oracle - Tips (add’l)
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;
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;
The URI to TrackBack this entry is: http://keeve.blogsome.com/2009/02/24/oracle-tips-addl/trackback/
No comments yet.
RSS feed for comments on this post.
Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>
Blog Redesigned by Karen Eve R. Eso