Technical Guide
Wednesday, September 8, 2010
View oracle table structure
SELECT * FROM ALL_TAB_COLUMNS WHERE TABLE_NAME='MY_TABLE';
In SQLPLUS, DESCRIBE command can be used.
DESCRIBE 'MY_TABLE';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment