SQLPlus Get
GET Command Syntax: GET [FILE] file_name [LIS[T]|NOL[IST]] GET Command Examples: GET file.sql...
Category: SQLPlus
SQLPlus Exit
EXIT Command Syntax: {EXIT|QUIT} [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] [COMMIT|ROLLBACK] EXIT Command Examples: Exit SQL*Plus : SQL> exit;...
SQLPlus Execute
EXECUTE Command Syntax: EXEC[UTE] statement EXECUTE Command Examples: SQL>execute statement SQL>exec statement SQL > @script.sql SQL > @/oracle/backup/script.sql...
SQLPlus Disconnect
DISCONNECT Command Syntax: DISC[ONNECT] DISCONNECT Command Examples: CONNECT user_1/password SELECT supplier_id, supplier_name FROM EMP_suppliers_view; DISCONNECT SET INSTANCE DBA_2 CONNECT user_2/password...
SQLPlus Describe
DESCRIBE Command Syntax: DESC[RIBE] {[schema.]object[@connect_identifier]} DESCRIBE Command Examples: DESCRIBE table_name DESCRIBE package_name CREATE TYPE suppliers AS OBJECT (supplier_id NUMBER(12), supplier_name VARCHAR2(250), city VARCHAR2(100) ); DESCRIBE suppliers...