Desc - Describe an Oracle Table, View, Synonym, package or Function:
"An alternative to the DESC command is selecting directly from the data dictionary -
DESC MY_TABLE
is equivalent to
SELECT
column_name 'Name',
nullable 'Null?',
concat(concat(concat(data_type,'('),data_length),')') 'Type'
FROM user_tab_columns
WHERE table_name='TABLE_NAME_TO_DESCRIBE';"
No comments:
Post a Comment