PROMPT PURPOSE: To send the specified message or a blank line to the user's screen. Normally, you use this command in command files to give information to the user. SYNTAX: PROMPT [text]
Where: text : is the text of the message you wish to display. If you omit text, PROMPT displays a blank line on the user's screen. Example: Here is PROMPT used with ACCEPT in command file ASKFORDEPT: SQL> GET ASKFORDEPT
1 PROMPT
2 PROMPT Please enter a department
3 PROMPT For example: 10, 20, 30, 40
4 ACCEPT NEWDEPT NUMBER PROMPT 'DEPT:>'
5* SELECT DNAME FROM DEPT WHERE DEPTNO = &NEWDEPT
If you run the file using @ASKFORDEPT, SQL*Plus displays: Please enter a department
For example: 10, 20, 30, 40
DEPT:>
You can enter a department number at the DEPT:> prompt. By default, SQL*Plus lists the line containing &NEWDEPT before and after substitution, and then displays the department name matching the number entered at the DEPT:> prompt. See also: /, @, accept, get, input, pause, run, start, commands.
|