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!

replace same value for multiple declaration of a same vriable

hemant_kFeb 23 2024

hi

select * from tbaadxx.gaxx where acct_opn_date='&dt'
union all
select * from tbaadxx.gaxx where acct_opn_date='&dt'
can I replace ‘&dt’ once if the value is same ?

I am trying this in sql developer

Comments
Post Details
Added on Feb 23 2024
5 comments
281 views