How to make variables work?
How does one add a variable to report header?
Example: REPHEADER LEFT 'DBA HISTORY TABLESPACE USAGE REPORT: ' || &schema_own
How does one add a predefined variable to another variable:
Example: DEFINE 1 = dba_hist_tabspc_usage || _DATE
How does one make the following statement work:
ACCEPT endDate CHAR DEFAULT _DATE PROMPT 'Enter end date (DD-MON-YYYY): '
|
-- SET PL/SQLPLUS OPTIONS SECTION --
SET ECHO OFF
SET FEED OFF
SET FLUSH OFF
SET VERIFY OFF
SET LINESIZE 136
SET PAGESIZE 66
SET SQLPROMPT '_CONNECT_IDENTIFIER > '
|
ACCEPT startDate CHAR DEFAULT 05-MAY-2007 PROMPT 'Enter start date (05-MAY-2007): '
ACCEPT endDate CHAR