All Tables with all fields
566462Nov 7 2007 — edited Nov 7 2007Hi, I need your knowledge and help.
I need something like this, and maybe somebody knows the solution:
Tablename_1
Field_1 Type
... ...
Tablename_2
Field_1 Type
Example:
Customer
ID Number
Name Varchar2(50)
Telefon Varchar2(30)
..... ....
It could be also like this, but what's important, is that i get all tables from one database or one schema.
something like (SELECT * FROM ALL_USER_TABLES;)
Customer ID Number
Customer Name Varchar2(50)
Customer Telefon Varchar2(30)
.............. ..... ....
Thanks for helping :)
Message was edited by:
Silvester