On Jul 24, 4:18 am, V <vladimir.mcbad...@gmail.com> wrote: > My specific problem here is the amount of time it takes to re-arrange > each statement - if I wanted to entirely re-write the statements then > to_date would be great. > > There is one apparently on this site but I don't want to sign up to > the site:- > > http://www.sswug.org/articles/guestarticle.aspx?id=26173
Vlad, Again, try to look at functionality of the Migration Workbench. I believe it is a part of SQL Developer (free product) now. It will convert your MS SQL views to Oracle views. In particular DatePart ==> TO_CHAR / TO_DATE functions. HTH Thomas --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
