Skip to Main Content

SQL Developer

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!

Variable like & and && working enhacement

776028May 31 2010 — edited Jun 1 2010
Hi,
when i using script like:

select * from products where order_date = to_date('&dates', '21012010') and check_date = to_date('&dates', '21012010')

i get 2 dialog boxes to enter date - but it's single variable! Why it asks twice? Or when i'll have one variable 10-20 times?

Ok, wehn i use:

select * from products where order_date = to_date('&&dates', '21012010') and check_date = to_date('&&dates', '21012010')

It asks once and never again even... if i run script several times.

I think it should be asking ONCE during script execution even if the same variable 20 times in the script in both cases.
And if i run script again - it should ask again to enter the variable.

And second BUG still is not fixed with exporting data from DBlinks:
1045488
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 29 2010
Added on May 31 2010
3 comments
1,574 views