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;

Comments »

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.

Leave a comment

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>



Anti-spam measure: please retype the above text into the box provided.






















Blog designed by Karen Eve Eso