SQL select question 1

[patrick118]

When you have an sql query you get a list back. It always show the comlumn names every few records. How do i get it not to this every few records but only the upper lever

example

get this

OWNER TABLE_NAME
------------------------------ ------------------------------
SYS LOGMNRT_SEED$
SYS AQ$_SCHEDULER$_EVENT_QTAB_I
SYS AQ$_SCHEDULER$_EVENT_QTAB_G
SYS AQ$_SCHEDULER$_EVENT_QTAB_H
SYS AQ$_SCHEDULER$_EVENT_QTAB_T
SYS AQ$_SCHEDULER$_JOBQTAB_I
SYS AQ$_SCHEDULER$_JOBQTAB_G
SYS AQ$_SCHEDULER$_JOBQTAB_H
SYS AQ$_SCHEDULER$_JOBQTAB_T
SYS RULE_SET_ROP$
SYS RULE_SET_IOT$

OWNER TABLE_NAME
------------------------------ ------------------------------
SYS RULE_SET_PR$
SYS ODCI_WARNINGS$
SYS ODCI_SECOBJ$
SYS WRI$_ADV_ASA_RECO_DATA
SYS PSTUBTBL
SYS CLUSTER_INSTANCES
SYS CLUSTER_NODES
SYS CLUSTER_DATABASES
SYS MAP_OBJECT
SYS ATEMPTAB$


but i would like it to show it like this

OWNER TABLE_NAME
------------------------------ ------------------------------
SYS LOGMNRT_SEED$
SYS AQ$_SCHEDULER$_EVENT_QTAB_I
SYS AQ$_SCHEDULER$_EVENT_QTAB_G
SYS AQ$_SCHEDULER$_EVENT_QTAB_H
SYS AQ$_SCHEDULER$_EVENT_QTAB_T
SYS AQ$_SCHEDULER$_JOBQTAB_I
SYS AQ$_SCHEDULER$_JOBQTAB_G
SYS AQ$_SCHEDULER$_JOBQTAB_H
SYS AQ$_SCHEDULER$_JOBQTAB_T
SYS RULE_SET_ROP$
SYS RULE_SET_IOT$
SYS RULE_SET_PR$
SYS ODCI_WARNINGS$
SYS ODCI_SECOBJ$
SYS WRI$_ADV_ASA_RECO_DATA
SYS PSTUBTBL
SYS CLUSTER_INSTANCES
SYS CLUSTER_NODES
SYS CLUSTER_DATABASES
SYS MAP_OBJECT
SYS ATEMPTAB$

 

[KenCunningham]

Hello Patrick. Try putting set pagesize 0 before your select statement.

 

[patrick118]

thank you