Category: SQLPlus

SQLPlus Show

SHOW Command Syntax: SHOW option SHOW Command Examples: SHOW LINESIZE SHOW ERRORS PROCEDURE procedure_name SHOW AUTORECOVERY SHOW INSTANCE SHOW LOGSOURCE SHOW SGA...

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...

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...