Set the prompt : Prompt « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. Prompt

Set the prompt

    

SQL>
SQL> --Set the prompt. Use predefined variables to access login
SQL> --user name and net service name
SQL> SET SQLPROMPT "&_user@&_connect_identifier(&database_name) >"
JAVA2S@XE(XE) >
JAVA2S@XE(XE) >SET TERMOUT ON
JAVA2S@XE(XE) >
JAVA2S@XE(XE) >SET FEEDBACK ON
JAVA2S@XE(XE) >
JAVA2S@XE(XE) >








Related examples in the same category

1.Use prompt to display information
2.PROMPT command outputs a line of data to the screen.
3.Use prompt to output message