bibi92
asked on
see a column type long
Hello,
How can I see a column type long with the select statement?
Thanks
bibi
How can I see a column type long with the select statement?
Thanks
bibi
set long 32767
select long_column from mytable;
refer
http://www.dba-oracle.com/t_select_long_table_column_sql.htm
select long_column from mytable;
refer
http://www.dba-oracle.com/t_select_long_table_column_sql.htm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks regards bibi
select t.TABLE_NAME, t.COLUMN_NAME, t.DATA_TYPE from user_tab_columns