SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to delete substitution variable

2893170Oct 26 2015 — edited Oct 26 2015

Hi,

I have a sql query which when run in either sql developer or Toad opens a window asking for a substitution variable (&SORTING). There is WHERE clause in a case statement as below

WHEN K.descr = 'SUPPORT (COPYING'

|| ' & '

|| 'SORTING FILES)' THEN 'ADDEDDESCR'

I'm thinking this particular statement is causing the variables window to pop up. Can some one please tell me if there is a workaround for this scenario? In TOAD i can right click on the SQL Editor and disable the Substitution variable pop up, but i will be using the sql query in SSRS (Reporting services) . Please advice

Thanks

Amy

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 23 2015

Added on Oct 26 2015

8 comments

854 views