Oracle Database Discussions

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!

Amersand problem in Sqlplus and Toad

N_RajAug 4 2016 — edited Aug 4 2016

Hi All,

we have oracle 11.2 on Redhat.

We are trying to insert the below statement into the table ref_data which has 4 columns.Last column of each row has select statement.

We executing by sqlplus ,it asks input value due to &.How to avoid the amersand problem.I tried set define off.

While executing in toad,it shows popup window.

Insert into ref_data (SK_SQL_ID,DATASET_NAME,DATASET_FREQUENCY,SQl_Query ) values (

(select max(SK_SQL_ID)+1 from ref_data),'v_purchase','1', 'SELECT ACC_PUR_HIST_ID||'&3'|| PRC_GUID||'&3'|| ACCNT_ID||'&3'|| BAN||'&3'|| sysdate from ACC_ACC );

Any Suggestions.

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 1 2016

Added on Aug 4 2016

#general-database-discussions

5 comments

263 views