131. Which view would you use to display the column names and DEFAULT values
for a table?
A. DBA_TABLES
B. DBA_COLUMNS
C. USER_COLUMNS
D. USER_TAB_COLUMNS
Answer: D
SELECT COLUMN_NAME,
DECODE(DATA_TYPE,'DATE' , DATA_TYPE ,'NUMBER' , DATA_TYPE ||
DECODE(DATA_SCALE,NULL,NULL,'(' || DATA_PRECISION || ',' || DATA_SCALE ||
')'),'VARCHAR2', DATA_TYPE || '(' || DATA_LENGTH || ')', NULL)DATA_TYPE
FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'INVOICES';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718944/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
