-- -------------------
-- Get Table's Columns
-- -------------------
select COLUMN_NAME,
DATA_TYPE
from ALL_TAB_COLUMNS
where TABLE_NAME = 'PS_TY_TL_SDF_EVT'
Wednesday, 5 May 2010
Getting Details Of A Table's Columns
The following Oracle SQL gets the columns in a table.
Subscribe to:
Posts (Atom)