Oracle SQL*Plus^TM Commands - S

Under construction

Use this command to write the contents of the SQL buffer to an operating system file.

SAV[E] filename [CRE[ATE] | REP[LACE] | APP[END]]

Back to top

Use this command to customise SQL*Plus' operations.

SET parameter_setting

Back to top

Use this command to look at the current state of your SQL*Plus environment.

SHO[W] [ | setting |

              ALL | BTI[TLE] |

              ERR[ORS] [{FUNCTION | PROCEDURE | PACKAGE |

                 PACKAGE BODY | TRIGGER | TYPE |

                 TYPE BODY | VIEW}

                 [owner.]object_name] |

              LNO | PARAMETER[S] [PARAMETER_NAME] |

              PNO | REL[EASE] | REPF[OTER] | REPH[EADER] |

              SGA | SPOO[L] | SQLCODE | TTL[TLE] | USER]

Back to top

Use this command to stop an Oracle instance. You need to be connected as SYSDBA, SYSOPER, or INTERNAL.

SHUTDOWN

              [NORMAL | IMMEDIATE | TRANSACTIONAL | ABORT]

Back to top

Use this command to write output to a text file.

SP[OOL] filename | OFF | OUT

Back to top

Use this command to execute an SQL*Plus script.

STA[RT] script_file [argument...]

Back to top

Use this command to start an Oracle instance and open a database.

STARTUP [FORCE] [RESTRICT]

              [PFILE = paremeter_filename]

              [MOUNT [OPEN [RECOVER]] database_name]]

              [[EXCLUSIVE | PARALLEL | SHARED] [RETRY]] | [NOMOUNT]

Back to top

Use this command to generate a file of SET commands based on the current state of those settings.

STORE SET filename

              [CRE[ATE] | REP[LACE] | APP[END]]

Back to top     Back to Index     Home     Serious Stuff

© 2001. Copyright Sue Nethercott.