If I set wrap off, then only the first column is displayed always. Is there something wrong with my SQL* setting? Thank you.
08-03-2003, 11:44 PM
I have found the reason. It's because the column size of this column_name is 4000! This table is created by oracle (8.1.7), I don't know why it's so big. Anyhow I can configure the format by COLUMN column_name format a20 to limit the displaying width.