SQLPlus Store
STORE Command Syntax: STORE SET file[.ext] [CRE[ATE]|REP[LACE]|APP[END]] STORE Command Example: STORE SET test STORE SET test.old APPEND...
Category: SQLPlus
SQLPlus Startup
STARTUP Command Syntax: STARTUP options | migrate_options Options syntax: [FORCE] [RESTRICT] [PFILE=filename] [QUIET] [ MOUNT [dbname] | [ OPEN [open_options] [dbname] ] | NOMOUNT ] Migrate_options syntax: [PFILE=filename] MIGRATE [QUIET] STARTUP Command Examples: STARTUP STARTUP NOMOUNT STARTUP MOUNT STARTUP OPEN DATABASE...
SQLPlus Start
START Command Syntax: START {url|file[.ext] } [arg…] START Command Example: Create a file TEST.sql SELECT id, name, price FROM products WHERE name=’&1′ AND price>&2; SQL> START TEST SAP 5000 or SQL> START HTTP://machine_name.domain:port/TEST.SQL SAP 5000...
SQLPlus Spool
SPOOL Command Syntax: SPO[OL] [file[.ext]|OFF|OUT] SPOOL Command Example: Record the output in the file TEST: SPOOL TEST Stop spooling and print the file: SPOOL OUT...
SQLPlus Shutdown
SHUTDOWN Command Syntax: SHUTDOWN [ABORT|IMMEDIATE|NORMAL|TRANSACTIONAL [LOCAL]] SHUTDOWN Command Example: SHUTDOWN...