You can use this command in command files to give information to the user. Example The following example shows the use of PROMPT in conjunction with ACCEPT in a command file called ASKFORDEPT. ASKFORDEPT contains the following SQL*Plus and SQL commands:...
When you include actions, specifies actions for SQL*Plus to take whenever a break occurs in the specified column (called the break column). (columncannot have a table or view appended to it. To achieve this, you can alias the column in the SQL statement.) A break is one of three event...
When you enter @@file_name.extinteractively, SQL*Plus runsfile_name.extfrom the current working directory or from the sameurlas the script from which it was called. If SQL*Plus does not find such a file, SQL*Plus searches a system-dependent path to find the file. Some operating systems ...