SQLPlus Del
DEL Command Syntax: DEL [n|n m|n *|n LAST|*|* n|* LAST|LAST] n = delete line n. n m = delete lines n through m. n * = delete line n through the current line. n LAST = delete line n through the...
Category: SQLPlus
SQLPlus Define
A value can be assigned to a variable using the command DEF [INE] of SQL * PLUS. Value defined to be used in a SELECT construction or a file of commands, the variable name prefixind with &. Variables can be emptied...
SQLPlus Copy
COPY Command Syntax: COPY {FROM database TO database} {APPEND|CREATE|INSERT|REPLACE} destination_table [(column, column, column, …)] USING query database = username[/password]@database_name COPY Command Examples: COPY FROM scott/password@dba_1 TO mike/password@dba_2 REPLACE dba_2.customers USING SELECT * FROM dba_1.customers COPY FROM scott/password@dba_1 CREATE new_products (product_id, product_name,...
SQLPlus Connect
CONNECT Command Syntax: CONN[ECT] { logon | / } [AS {SYSOPER|SYSDBA}] logon = username/password[@connect_identifier] CONNECT Command Examples: CONNECT BASE/password@DBA CONNECT BASE CONNECT BASE/password AS SYSDBA CONNECT / AS SYSDBA...
SQLPlus Compute
COMPUTE Command Syntax: COMP[UTE] [function [LAB[EL] text] … OF {expr|column|alias} … ON {expr|column|alias|REPORT|ROW} … function = AVG, COU[NT], MIN[IMUM], MAX[IMUM], NUM[BER], SUM, STD, VAR[IANCE] COMPUTE Command Examples: COMPUTE SUM OF PRICE ON REPORT BREAK ON REPORT COLUMN DUMMY HEADING ” SELECT...