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!

where clause

newbiegalNov 5 2009 — edited Nov 5 2009

HI all,

I've this query in sql server procedure, I'm converting to Oracle procedure..

create procedure...
declare @ACI varchar(5)
 create table #tmp (Res nvarchar(5)) 
 insert into #tmp
        exec ('SELECT ACI FROM USER1.MAYR WHERE MA_CODE=''' + @mayrto + '''') at SER1
 select @ACI =Res from #tmp 
 ...

Converting this to Oracle, will the select query be

select aci from user1.mayr where ma_code = '''@mayrto''''

Please give me your suggestions..thanks a lot

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2009

Added on Nov 5 2009

8 comments

332 views