SQLPlus / UNIX (C'est un DEFI) !!!!
Fermé
mike24111
Messages postés
1
Date d'inscription
jeudi 7 mars 2002
Statut
Membre
Dernière intervention
7 mars 2002
-
7 mars 2002 à 09:52
Samir - 8 mars 2002 à 10:26
Samir - 8 mars 2002 à 10:26
Bonjour,
Je script en SQLPlus et je veux faire un TTITLE ou un PROMPT avec des le contenu de variable UNIX :
ex : PROMPT le nom du serveur est : !hostname
Bon le !hostname etant pour avoir le nom du serveur ca marche en dehors du PROMPT mais dans le PROMPT je ne trouve pas la juste syntaxe !
MERCI d'avance mais bon ca m'etonnerais que vous trouveriez ! ;-)
Je script en SQLPlus et je veux faire un TTITLE ou un PROMPT avec des le contenu de variable UNIX :
ex : PROMPT le nom du serveur est : !hostname
Bon le !hostname etant pour avoir le nom du serveur ca marche en dehors du PROMPT mais dans le PROMPT je ne trouve pas la juste syntaxe !
MERCI d'avance mais bon ca m'etonnerais que vous trouveriez ! ;-)
1 réponse
si ca peut t´aider:
----------------------------------------------------------------------------PROMPT
Purpose
Sends the specified message or a blank line to the user's screen.
Syntax
PROMPT [text]
Terms and Clauses
Refer to the following for a description of the term or clause:
text
Represents the text of the message you wish to display. If you omit text, PROMPT displays a blank line on the user's screen.
Usage Notes
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:
PROMPT
PROMPT Please enter a valid department
PROMPT For example: 10, 20, 30, 40
ACCEPT NEWDEPT NUMBER PROMPT 'DEPT:> '
SELECT DNAME FROM DEPT
WHERE DEPTNO = &NEWDEPT
Assume you run the file using START or @:
SQL> @ASKFORDEPT
SQL*Plus displays the following prompts:
Please enter a valid department
For example: 10, 20, 30, 40
DEPT:>
You can enter a department number at the prompt DEPT:>. By default, SQL*Plus lists the line containing &NEWDEPT before and after substitution, and then displays the department name corresponding to the number entered at the DEPT:> prompt.
----------------------------------------------------------------------------
----------------------------------------------------------------------------PROMPT
Purpose
Sends the specified message or a blank line to the user's screen.
Syntax
PROMPT [text]
Terms and Clauses
Refer to the following for a description of the term or clause:
text
Represents the text of the message you wish to display. If you omit text, PROMPT displays a blank line on the user's screen.
Usage Notes
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:
PROMPT
PROMPT Please enter a valid department
PROMPT For example: 10, 20, 30, 40
ACCEPT NEWDEPT NUMBER PROMPT 'DEPT:> '
SELECT DNAME FROM DEPT
WHERE DEPTNO = &NEWDEPT
Assume you run the file using START or @:
SQL> @ASKFORDEPT
SQL*Plus displays the following prompts:
Please enter a valid department
For example: 10, 20, 30, 40
DEPT:>
You can enter a department number at the prompt DEPT:>. By default, SQL*Plus lists the line containing &NEWDEPT before and after substitution, and then displays the department name corresponding to the number entered at the DEPT:> prompt.
----------------------------------------------------------------------------