Oracle schema

[Silly Boy]

Hi every body! Please tell me! how can i get list of all tables in oracle database and all fields of a table? Thanks! xyz

[gnjunge]

This is the ANSI SQL way to get all tables: select TABLE_NAME from INFORMATION_SCHEMA.TABLES

[vaibhavcs55]

test:laugh:

[d_vaibhav]

you can use select * from tab to get the list of all tables vaibhav.

[Guillermo Rivero]

SELECT * FROM USER_TABLES Free your mind...