-
Junior Member
Re: Query to find structure of a table
DESC BOOk_NAME;
eg:
DESC BOOK;
BOOK is name of table.
-
Junior Member
Re: Query to find structure of a table
Sp_help is for SQL server
DESC is for ORACLE DB
Last edited by admin; 11-05-2012 at 12:27 AM.
-
Junior Member
Re: Query to find structure of a table
Select column_name, data_type, data_length, data_precision, data_scale from ALL_TAB_COLUMNS
where table_name = 'EMP';
or
desc emp;
Last edited by admin; 01-22-2013 at 07:07 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules