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!

SYBASE VS ORACLE

606658Jul 22 2008 — edited Jul 22 2008
Hi All,
I am hopins someone can help me we move from a sybase platform to an oracle and I have an sql statement that works in sybase that I am trying to implement to oracle without much success.
oracle

Sybase

delete from tablex
where bookmo in (
select substring(convert(char(4),dateadd(month,-3,getdate()),12),1,4))


oracle

delete from tablex
where bookmo in (to_char(substr(bookmo,1,6)),add_months(sysdate,-3),sysdate,'mm' )
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2008
Added on Jul 22 2008
6 comments
1,034 views