Snippet Name: SQL*Plus Configuration
Description: How you can show configuration setting.
Also see:
» SQL*Plus SQL Prompt
» SQL*Plus Spool Command
» SQL*Plus Display commands
» SQL*Plus Describe
» SQL*Plus connect
» SQL*Plus formatting
Comment: (none)
Language:
Highlight Mode: HTML4STRICT
Last Modified: March 07th, 2009
|
Display SQL*Plus configuration parameters
show all
CREATE PROCEDURE test1 IS
BEGIN
ifasdfn;
END;
/
show errors
Display the connect identifier for the default instance
show instance
Display the location for archive logs
show logsource
Display the initialization parameters
show parameter undo
Display the Oracle release number
show release
Display the current user information
show user
|
