Skip to Main Content
Forums

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!

Select ALL_TAB_COLUMNS

587294Jul 28 2008 — edited Jul 28 2008
Hi all,
I got One Select Query as " SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = :tablename ".
But with this i am getting only ( OWNER, TABLE_NAME, COLUMN_NAME, DATATYPE).
But i want the following columns also:
(character maximum length, numeric scale, is nullable)
How to get this data also please ?
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 25 2008
Added on Jul 28 2008
5 comments
8,261 views