Shulou(Shulou.com)06/01 Report--

Select ROWNUM, T.*

From (Select column_name

Case

When data_type = 'NUMBER' Then

Data_type |'('| | nvl (to_char (data_precision),'*') | |,'| |

Nvl (to_char (data_scale), 0) | |')'

When data_type In ('VARCHAR2',' CHAR') Then

Data_type |'('| | to_char (CHAR_LENGTH) | |')'

Else

DATA_TYPE

End As DATA_TYPE

Decode (NULLABLE,'Y','N','N','Y') As Mandatory

Data_type AS data_type1

Char_length

Data_precision

Data_scale

From user_tab_columns c

Where table_name = 'CIS_1WMP_ASM_ADDR_UM_RN'

Order By c.COLUMN_ID) T

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.