Link to home
Start Free TrialLog in
Avatar of bibi92
bibi92Flag for France

asked on

see a column type long

Hello,

How can I see a column type long with the select statement?

Thanks

bibi
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image


select t.TABLE_NAME, t.COLUMN_NAME, t.DATA_TYPE from user_tab_columns
Avatar of Pratima
set long 32767
select long_column from mytable;

refer
http://www.dba-oracle.com/t_select_long_table_column_sql.htm
ASKER CERTIFIED SOLUTION
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of bibi92

ASKER

Thanks regards bibi