SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 06:50 PM
| ||||
| ||||
 ANN: SQL Converter (Oracle -> MS SQLServer) Hi all, I have developed a SQL conversion tool named 'JoyJoin'. It converts Oracle SQL to ANSI SQL. eg. This tool converts: select a.f1,b.f2 from table1 a , table2 b where a.f1 = b.f1(+) to select a.f1,b.f2 from table1 a left join table2 b on a.f1 = b.f1 select decode(a.f1,'-1','True','False') from table1 a to select (case a.f1 when '-1' then 'True' else 'False' end) from table1 a select a.field1 from table1 where rownum <= 10 order by a.field1 to select top 10 a.field1 from table1 order by a.field1 select '1' || '2||3' from dual to select '1' + '2||3' Dowdload and try it at : http://www.joyjoin.com You can use all features of the product until 31 Jan 2004. Thank you.      |
|
02-28-2008, 06:50 PM
| ||||
| ||||
| Re: ANN: SQL Converter (Oracle -> MS SQLServer) JoyJoin wrote: > Hi all, > I have developed a SQL conversion tool named 'JoyJoin'. > It converts Oracle SQL to ANSI SQL. > > eg. This tool converts: > > select a.f1,b.f2 from table1 a , table2 b where a.f1 = b.f1(+) > to > select a.f1,b.f2 from table1 a left join table2 b on a.f1 = b.f1 > > select decode(a.f1,'-1','True','False') from table1 a > to > select (case a.f1 when '-1' then 'True' else 'False' end) from table1 a > > select a.field1 from table1 where rownum <= 10 order by a.field1 > to > select top 10 a.field1 from table1 order by a.field1 > > select '1' || '2||3' from dual > to > select '1' + '2||3' > > > Dowdload and try it at : > http://www.joyjoin.com > > You can use all features of the product until 31 Jan 2004. > > Thank you. How do you convert Oracle to ANSI SQL when: A) There is no such thing as ANSI SQL. Perhaps you mean TransactSQL. and B) Oracle, as of 9i, has and uses all of the syntaxes you are trying to convert? Oracle is both ISO and ANSI compliant. ANSI joins are fully supported. -- Daniel Morgan http://www.outreach.washington.edu/e...ad/oad_crs.asp http://www.outreach.washington.edu/e...oa/aoa_crs.asp damorgan@x.washington.edu (replace 'x' with a 'u' to reply) |
Linear Mode
