SQL*Plus

ACCEPT

ACCEPT tspace CHAR PROMPT 'Enter Tablespace '

Use &tspace or &&tspace to reference this variable in your SQLData type can be CHAR, NUMBER or DATEYou can specify a FORMAT. Entries that don't match the FORMAT spec will be rejected.You can specify a DEFAULT which will take effect if the user presses Enter without entering any other characters.You can HIDE the user's response (useful for passwords).If you specify NOMPROMPT instead of PROMPT then no prompt will be shown (useful if you have already prompted using standalone PROMPT commands.

BREAK

BREAK ON tablespace SKIP 1

COMPUTE

COMPUTE SUM LABEL 'total_mb' OF size_mb ON tablespace

COLUMN

COLUMN querycol FORMAT a30

PROMPT

PROMPT

PROMPT The line above shows a blank line. This line shows this text

PROMPT The next line shows the current value of the tspace variable

PROMPT &tspace

Bibliography