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






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