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...
Author: codertutor_3o6d0o
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...
SQLPlus Column
COLUMN command Specifies display characteristics for a given column or lists the current display characteristics for a single column or for all columns. COLUMN Command Syntax: COL[UMN] [{column|expr} [option …]] option is one of the next clauses: ALI[AS] alias CLE[AR] ENTMAP...