Tuesday, May 22, 2007
Desc - Describe an Oracle Table, View, Synonym, package or Function
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';"
Subscribe to:
Post Comments (Atom)
-
A while back I answered a question on Stack Overflow asking about the relative popularity of The Art of Computer Programming . I replied wit... -
First, let's draw a cube: cube(10,true); Now, let's animate a 360 degree turntable view of the cube: rotate([0,0,$... -
I learned a lot from Laurens Kuiper's blog post Testing out DuckDB's Full Text Search Extension , but unfortunately couldn't fin...
No comments:
Post a Comment