Geek asks and answers

Oracle sqlplus row size

In SQLplus, why did I set the row size max (32767), it still does not match the format. how to fix it?

select * from user_tables
TABLE_NAME                     TABLESPACE_NAME                CLUSTER_NAME                   IOT_NAME                       STATUS     PCT_FREE   PCT_U
_TRANS  MAX_TRANS INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE  FREELISTS FREELIST_GROUPS LOG B   NUM_ROWS    BLOCKS EMPTY_BLOCKS  A
  CHAIN_CNT AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS DEGREE    INSTANCES  CACHE TABLE_LO SAMPLE_SIZE LAST_ANAL PAR IOT_TYPE     T S NE
_ ROW_MOVE GLO USE DURATION       SKIP_COR MON CLUSTER_OWNER                  DEPENDEN COMPRESS COMPRESS_FOR       DRO REA
+3
source share
3 answers

This is done as a comment above, but presenting as an answer here:

If you run it from the command console (for example, the Windows command line), the console will wrap your lines regardless of yours LINESIZE. Upload it to the file and you will see the effect of adjusting the length of the line, which will be LOTS of whitespace.

+8
source 
set lines 9999
set trimspool on
spool myfile.txt
select * from user_tables;
spool off

Bring myfile.txt to the editor, the columns will line up. set trimspool on will get rid of the trailing space, which confuses you even more.

+4
source

, sql * plus?

SET LINESIZE ###

32767 , ?

+2

More articles:


All Articles