eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

SYS.DBMS_PREUP dependencies on DUAL

Line 774: SELECT USER INTO tmp_varchar1 FROM SYS.DUAL;

770: --
771: pStarHeader := CenterLine ('*****************************************');
772:
773: -- Check for SYSDBA
774: SELECT USER INTO tmp_varchar1 FROM SYS.DUAL;
775: IF tmp_varchar1 != 'SYS' THEN
776: EXECUTE IMMEDIATE 'BEGIN
777: RAISE_APPLICATION_ERROR (-20000,
778: ''These functions must be run AS SYSDBA''); END;';

Line 782: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_name FROM sys.dual' INTO con_name;

778: ''These functions must be run AS SYSDBA''); END;';
779: END IF;
780:
781: EXECUTE IMMEDIATE 'SELECT name FROM v$database' INTO db_name;
782: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_name FROM sys.dual' INTO con_name;
783: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_id FROM sys.dual' INTO con_id;
784: EXECUTE IMMEDIATE 'SELECT version FROM v$instance' INTO db_version;
785:
786: EXECUTE IMMEDIATE 'SELECT value FROM v$parameter WHERE name = ''compatible'''

Line 783: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_id FROM sys.dual' INTO con_id;

779: END IF;
780:
781: EXECUTE IMMEDIATE 'SELECT name FROM v$database' INTO db_name;
782: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_name FROM sys.dual' INTO con_name;
783: EXECUTE IMMEDIATE 'SELECT dbms_preup.get_con_id FROM sys.dual' INTO con_id;
784: EXECUTE IMMEDIATE 'SELECT version FROM v$instance' INTO db_version;
785:
786: EXECUTE IMMEDIATE 'SELECT value FROM v$parameter WHERE name = ''compatible'''
787: INTO db_compat;

Line 1597: store_renamed(idx,'nls_union_currency','nls_dual_currency');

1593: store_renamed(idx,'mview_rewrite_enabled','query_rewrite_enabled');
1594: store_renamed(idx,'rewrite_integrity','query_rewrite_integrity');
1595:
1596: -- Initialization Parameters Renamed in Release 8.1.5 --
1597: store_renamed(idx,'nls_union_currency','nls_dual_currency');
1598: store_renamed(idx,'parallel_transaction_recovery',
1599: 'fast_start_parallel_rollback');
1600:
1601: -- Initialization Parameters Renamed in Release 9.0.1 --

Line 2182: EXECUTE IMMEDIATE 'SELECT FLOWS_010500.wwv_flows_release from sys.dual'

2178:
2179: -- Check for HTML DB in 9.2.0 and 10.1 databases
2180: -- 121: Is this needed
2181: BEGIN
2182: EXECUTE IMMEDIATE 'SELECT FLOWS_010500.wwv_flows_release from sys.dual'
2183: INTO c_version;
2184: store_comp(apex,'FLOWS_010500',c_version, NULL);
2185: EXCEPTION
2186: WHEN OTHERS THEN NULL;

Line 2191: EXECUTE IMMEDIATE 'SELECT FLOWS_010600.wwv_flows_release from sys.dual'

2187: END;
2188:
2189: -- 121: Is this needed
2190: BEGIN
2191: EXECUTE IMMEDIATE 'SELECT FLOWS_010600.wwv_flows_release from sys.dual'
2192: INTO c_version;
2193: store_comp(apex,'FLOWS_010600',c_version, NULL);
2194: EXCEPTION
2195: WHEN OTHERS THEN NULL;

Line 2200: EXECUTE IMMEDIATE 'SELECT FLOWS_020000.wwv_flows_release from sys.dual'

2196: END;
2197:
2198: -- Check for APEX in 10.2 databases
2199: BEGIN
2200: EXECUTE IMMEDIATE 'SELECT FLOWS_020000.wwv_flows_release from sys.dual'
2201: INTO c_version;
2202: store_comp(apex,'FLOWS_020000',c_version, NULL);
2203: EXCEPTION
2204: WHEN OTHERS THEN NULL;

Line 2208: EXECUTE IMMEDIATE 'SELECT FLOWS_020100.wwv_flows_release from sys.dual'

2204: WHEN OTHERS THEN NULL;
2205: END;
2206:
2207: BEGIN
2208: EXECUTE IMMEDIATE 'SELECT FLOWS_020100.wwv_flows_release from sys.dual'
2209: INTO c_version;
2210: store_comp(apex,'FLOWS_020100',c_version, NULL);
2211: EXCEPTION
2212: WHEN OTHERS THEN NULL;

Line 3511: EXECUTE IMMEDIATE 'SELECT TO_CHAR(SYSTIMESTAMP,''YYYY-MM-DD HH24:MI:SS '') FROM SYS.DUAL'

3507: dbms_output.put_line('XXX pOutputLocation ' || pOutputLocation);
3508: dbms_output.put_line('XXX pPostScriptFname ' || pPostScriptFname);
3509: END IF;
3510:
3511: EXECUTE IMMEDIATE 'SELECT TO_CHAR(SYSTIMESTAMP,''YYYY-MM-DD HH24:MI:SS '') FROM SYS.DUAL'
3512: INTO timeinfo;
3513:
3514: --
3515: -- The linesize at 750 allows the buffering of some of the help text

Line 3542: DisplayLine (pPreScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');

3538: DisplayLine (pPreScriptUFT, 'con_name varchar2(40);');
3539: DisplayBlankLine (pPreScriptUFT);
3540: DisplayLine (pPreScriptUFT, 'BEGIN ');
3541: DisplayLine (pPreScriptUFT, 'execute immediate ');
3542: DisplayLine (pPreScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');
3543:
3544: -- If the session currently connected to is of a database or container that
3545: -- matches the name in the IF stmt, then stay in the block and run the
3546: -- fixup steps.

Line 3550: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;

3546: -- fixup steps.
3547: -- Else, if the names do not match, then continue on to the next block in
3548: -- the fixup script.
3549: EXECUTE IMMEDIATE
3550: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;
3551: DisplayBlankLine (pPreScriptUFT);
3552: DisplayLine (pPreScriptUFT, 'IF con_name = ''' || con_name || ''' THEN');
3553: DisplayBlankLine (pPreScriptUFT);
3554:

Line 3586: DisplayLine (pPostScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');

3582: DisplayLine (pPostScriptUFT, 'con_name varchar2(40);');
3583: DisplayBlankLine (pPostScriptUFT);
3584: DisplayLine (pPostScriptUFT, 'BEGIN ');
3585: DisplayLine (pPostScriptUFT, 'execute immediate ');
3586: DisplayLine (pPostScriptUFT, ' ''select dbms_preup.get_con_name from sys.dual'' into con_name;');
3587:
3588: -- If the session currently connected to is of a database or container that
3589: -- matches the name in the IF block, then stay in the loop and run the
3590: -- fixup steps.

Line 3594: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;

3590: -- fixup steps.
3591: -- Else, if the names do not match, then continue on to the next block in
3592: -- the fixup script.
3593: EXECUTE IMMEDIATE
3594: 'select dbms_preup.get_con_name from sys.dual' INTO con_name;
3595: DisplayBlankLine (pPostScriptUFT);
3596: DisplayLine (pPostScriptUFT, 'IF con_name = ''' || con_name || ''' THEN');
3597: DisplayBlankLine (pPostScriptUFT);
3598:

Line 3627: EXECUTE IMMEDIATE 'SELECT TO_CHAR(SYSTIMESTAMP,''YYYY-MM-DD HH24:MI:SS '') FROM SYS.DUAL'

3623: DisplayLine (pPostScriptUFT, 'BEGIN dbms_preup.fixup_summary(FALSE); END;');
3624: DisplayBlankLine (pPostScriptUFT);
3625:
3626:
3627: EXECUTE IMMEDIATE 'SELECT TO_CHAR(SYSTIMESTAMP,''YYYY-MM-DD HH24:MI:SS '') FROM SYS.DUAL'
3628: INTO timeinfo;
3629:
3630: DisplayLine (pPreScriptUFT, 'BEGIN');
3631: DisplayLine (pPreScriptUFT,

Line 12150: ''',1,6), ''.'', '''')) FROM sys.dual';

12146:
12147: -- convert c_apex_version to number
12148: convert_stmt :=
12149: 'SELECT to_number(replace(substr(''' || c_apex_version ||
12150: ''',1,6), ''.'', '''')) FROM sys.dual';
12151: EXECUTE IMMEDIATE convert_stmt INTO n_shipped_version;
12152:
12153: -- if current apex version is same or newer than the apex version in
12154: -- the target oracle home, then just return success

Line 12767: 'select upper(SYS_CONTEXT(''USERENV'', ''CON_NAME'')) from sys.dual'

12763:
12764: -- get container name
12765: begin
12766: execute immediate
12767: 'select upper(SYS_CONTEXT(''USERENV'', ''CON_NAME'')) from sys.dual'
12768: into conName;
12769: exception
12770: WHEN e_noParamFound THEN conName := '';
12771: end;

Line 12795: 'select SYS_CONTEXT(''USERENV'', ''CON_ID'') from sys.dual'

12791: PRAGMA exception_init(e_noParamFound, -2003);
12792: BEGIN
12793: begin
12794: execute immediate
12795: 'select SYS_CONTEXT(''USERENV'', ''CON_ID'') from sys.dual'
12796: into conId;
12797: exception
12798: WHEN e_noParamFound THEN conId := 0;
12799: end;