SQLPlus Save
SAVE Command Syntax: SAV[E] [FILE] file[.ext] [CRE[ATE]|REP[LACE]|APP[END]] SAVE Command Example: Save file with SQL extension: SAVE file_name...
Author: codertutor_3o6d0o
SQLPlus Run
RUN Command Syntax: RUN RUN Command Example: SELECT PRODUCT_ID FROM PRODUCTS_VIEW WHERE PRICE > 5000 To RUN the sql query just press Enter....
SQLPlus Repheader
REPHEADER Command Syntax: REPHEADER [PAGE] [printspec [text|variable] …] | [ON|OFF] REPHEADER Command Example: REPHEADER PAGE CENTER ‘SALES LISTING REPORT’ TTITLE RIGHT ‘Page: ‘ FORMAT 999 SQL.PNO SELECT CUSTOMER, SALE_SUM FROM SALES_VIEW WHERE SALE_SUM > 5000; Page: 1 SALES LISTING REPORT Page:...
SQLPlus Repfooter
REPFOOTER Command Syntax: REPFOOTER [PAGE] [printspec [text|variable] …] | [ON|OFF] REPFOOTER Command Example: REPFOOTER PAGE CENTER ‘END SALES LISTING REPORT’ TTITLE RIGHT ‘Page: ‘ FORMAT 999 SQL.PNO SELECT CUSTOMER, SALE_SUM FROM SALES_VIEW WHERE SALE_SUM > 5000; CUSTOMER SALE_SUM ————————- ———- Customer_1...
SQLPlus Remark
REMARK Command Syntax: REM[ARK] REMARK Command Example: REM COMPUTE uses BREAK ON REPORT to break on end of table BREAK ON REPORT COMPUTE SUM OF “CONTRACT 1” “CONTRACT 2” “CONTRACT 3” “TOTAL BY PRODUCT_ID” ON REPORT REM Each column displays the...