-
SQL* environment setting
Hi, all
I have got a problem with my SQL* 8.1.7 setting. When I select more than 1 columns from any table, if I set wrap environment to ON, all the rows will be displayed in one column, looks like this:
TABLE_NAME
------------------
COLUMN_NAME
------------------
CONSTRAINT_NAME
------------------
CBU_AD_USER
V_USER_ID
SYS_C00917
CBU_AD_USER
V_USER_NAME
SYS_C00918
CBU_AD_USER
V_PASSWORD
SYS_C00919
If I set wrap off, then only the first column is displayed always. Is there something wrong with my SQL* setting? Thank you.
-
Hi, all
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|