Feature
| SQL*DBA
| Server Manager
|
DESCRIBE
| DESCRIBE <object name>
| DESCRIBE <object type> <object name>
|
DESCRIBE for PL/SQL
| Lists information about the procedure's arguments in a tabular form
| Lists the definition of the procedure's arguments
|
PRINT <no args>
| Does nothing
| Prints all defined variables
|
PRINT (before connect)
| SQLDBA> print a DBA-00302: not connected to a database
| SVRMGR> print a A ---------- 10
|
SET COMPATIBILITY NATIVE
| Unsupported
| Server Manager uses the native SQL of the database to which you are connected
|
SHOW <no args>
| SQLDBA> show show * DBA-00115: unexpected end of command
| Prints current Server Manager settings
|
SPOOL <no args>
| SQLDBA> spool File sqldba.log opened... No prompt
| SVRMGR> spool Name for the spool file: (svrmgr.log) Prompts for a filename. The default is SVRMGR.LOG.
|
STARTUP
| If any step of STARTUP fails, SQL*DBA backs out and leaves the database in a shutdown state.
| If any step of STARTUP fails, Server Manager leaves the database in its current state. For example, if an error is encountered after the mount stage, Server Manager leaves the database mounted.
|
VARIABLE a CHAR
| Default size is 1
| Default size is CHARWIDTH
|
@<no args>
| SQLDBA> @ ORA-07225: ... Prints an error
| SVRMGR> @ Name of script file: Prompts for the name of the file
|
Empty line
| SQLDBA> garbage 2> SQLDBA>; SQLDBA>
| SVRMGR> garbage 2> 3>; garbage * ORA-00900: invalid SQL statement SVRMGR>
|