SQL Performance (MOSC)

MOSC Banner

SQLT sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip 19.1.200226

The older versions of SQLT allowed to invoke a run from a script; after the implementation of the "SQL Description [S] " it is not possible to run it from a script as a 3rd parameter.


Changing the code from :

ACC sql_desc PROMPT 'SQL Description [S]: ';

to

DEF sql_desc ='^3';

set termout off

select NVL(SUBSTR(UPPER(TRIM('^^sql_desc')),1,1),'S') sql_desc from dual;


allows to provide this field a a 3rd parameter.



Please review your code and if possible please make the input consistent to the other parameter.


Thanks a lot in advance

Brigitte

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center