Skip to Main Content
Forums

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!

spool query with parameter

happy10319Feb 28 2019 — edited Feb 28 2019

hi all,

on 12c

I run a query with bind parameter for mytable.col1  and spool it.

In spool file I see

old   2: where col1=...

new   2: where col1=

How can I avoid these two lines:

old   2: where col1=...

new   2: where col1=

I do not want them in spool file.

Thanks.
This post has been answered by L. Fernigrini on Feb 28 2019
Jump to Answer
Comments
Post Details
Added on Feb 28 2019
4 comments
292 views