i have a schema - myschema in an oracle database
i want to export all the table names owned by myschema along with the column names(just the names not the datatypes ) etc... (to excel or some text file )
to get the table name for myschema, i can run the sql - select table_name from user_tables;
but i want to get column names for each and every table in user_tables
is there any sql to get column names ?
i want to create a usable excel-spreadsheet with table names & column names in myschema....
thanks a lot