SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to get the user created tables.

514933May 25 2006 — edited May 25 2006

hi,

i'm new to oracle 10g xe. i created 3 tables and inserted data successfully. i want to show the list of all tables which are created by the user.

in the previous versions i used the syntax, "select * from tab;".
it retreives all the tables created by user and oracle.

i need any syntax to get only the user created tables.

i need ur suggestions.

regards,
pavan.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2006

Added on May 25 2006

1 comment

499 views