Where can I find a short comparision of SQL comands of both products?
I need to find the Oracle equivalents of some SQL Server commands
(e.g. date functions).

On May 23, 9:02 am, Geri Reshef <GeriRes...@gmail.com> wrote:
> Where can I find a short comparision of SQL comands of both products?
> I need to find the Oracle equivalents of some SQL Server commands
> (e.g. date functions).

How about googling for them? This page pops up among top 3 for "oracle
mssql sql difference":

http://www.bristle.com/Tips/SQL.htm#...s_sql_serv er

and it has some helpful links to further reading. Also, see
http://tahiti.oracle.com for complete Oracle documentation.

Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com

On May 23, 1:02 am, Geri Reshef <GeriRes...@gmail.com> wrote:
> Where can I find a short comparision of SQL comands of both products?
> I need to find the Oracle equivalents of some SQL Server commands
> (e.g. date functions).

The Oracle single row functions such at sysdate, to_date, add_months,
and trunc can be found in the SQL manual.

UT1 > set echo on
UT1 > @t7
UT1 > select
2 sysdate Today
3 ,add_months(sysdate, -1) Last_Month
4 ,sysdate + 1 Tomorrow
5 ,to_char(sysdate,'YYYYMMDD HH24:MI:SS') With_Time
6 from dual
7 /

TODAY LAST_MONT TOMORROW WITH_TIME
--------- --------- --------- -----------------
23-MAY-07 23-APR-07 24-MAY-07 20070523 09:41:53

HTH -- Mark D Powell --

Geri Reshef wrote:
> Where can I find a short comparision of SQL comands of both products?
> I need to find the Oracle equivalents of some SQL Server commands
> (e.g. date functions).

www.psoug.org
click on Morgan's Library
click on Microsoft SQL Server 2005 Comparison

It is not complete, and undoubtedly contains a few errors, but it will
get you started.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Geri Reshef wrote:
> Where can I find a short comparision of SQL comands of both products?
> I need to find the Oracle equivalents of some SQL Server commands
> (e.g. date functions).
>

This is one of the better ones I've found:

http://www.microsoft.com/technet/pro....mspx?mfr=true

It's written by Microsoft in the hopes you'll migrate to SQL Server, but
you can use the doc to go the other way too!

Cheers,
Brian


--
================================================== =================

Brian Peasland
dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

Brian Peasland wrote:
> Geri Reshef wrote:
>> Where can I find a short comparision of SQL comands of both products?
>> I need to find the Oracle equivalents of some SQL Server commands
>> (e.g. date functions).
>>
>
> This is one of the better ones I've found:
>
> http://www.microsoft.com/technet/pro....mspx?mfr=true
>
>
> It's written by Microsoft in the hopes you'll migrate to SQL Server, but
> you can use the doc to go the other way too!
>
> Cheers,
> Brian

I started reviewing the site but had to stop when my laughter started
bothering those around me.

This is priceless:
"Clustering is a shared disk, hardware solution protecting against
computer failure."

Forget cache fusion.
Forget TAF and FCF.
Forget that RAC is not a hardware solution.
Forget the fact that shared disk is a very small part of RAC.

It is best to suspend one's synapses when reading Microsoft docs.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On May 23, 10:09 am, Brian Peasland <d...@nospam.peasland.net> wrote:
> Geri Reshef wrote:
> > Where can I find a short comparision of SQL comands of both products?
> > I need to find the Oracle equivalents of some SQL Server commands
> > (e.g. date functions).
>
> This is one of the better ones I've found:
>
> http://www.microsoft.com/technet/pro...eskit/part2/c0...
>
> It's written by Microsoft in the hopes you'll migrate to SQL Server, but
> you can use the doc to go the other way too!
>
> Cheers,
> Brian
>
> --
> ================================================== =================
>
> Brian Peasland
> d...@nospam.peasland.nethttp://www.peasland.net
>
> Remove the "nospam." from the email address to email me.
>
> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown
>
> --
> Posted via a free Usenet account fromhttp://www.teranews.com

I've taken and passed the MSSQL and Oracle cert tests and that doc is
pretty bad.... Oracle 7...? Why not compare 10g to SQLServer 7?
Whew!

Why not simply know what function you need and refer to the actual
Oracle docs rather than some comparison list? It doesn't take that
long.

http://download-east.oracle.com/docs...b14200/toc.htm

On May 23, 1:02 am, Geri Reshef <GeriRes...@gmail.com> wrote:
> Where can I find a short comparision of SQL comands of both products?
> I need to find the Oracle equivalents of some SQL Server commands
> (e.g. date functions).

There's no DATEDIFF in Oracle. But you can create a function that
equates.
http://msdn2.microsoft.com/en-us/lib...9(SQL.80).aspx


http://asktom.oracle.com/tkyte/Misc/DateDiff.html

EscVector wrote:
> On May 23, 1:02 am, Geri Reshef <GeriRes...@gmail.com> wrote:
>> Where can I find a short comparision of SQL comands of both products?
>> I need to find the Oracle equivalents of some SQL Server commands
>> (e.g. date functions).
>
> There's no DATEDIFF in Oracle. But you can create a function that
> equates.
> http://msdn2.microsoft.com/en-us/lib...9(SQL.80).aspx
>
>
> http://asktom.oracle.com/tkyte/Misc/DateDiff.html

You can also use the minus (-) operator.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On May 24, 5:11 pm, DA Morgan <damor...@psoug.org> wrote:
> EscVector wrote:
> > On May 23, 1:02 am, Geri Reshef <GeriRes...@gmail.com> wrote:
> >> Where can I find a short comparision of SQL comands of both products?
> >> I need to find the Oracle equivalents of some SQL Server commands
> >> (e.g. date functions).
>
> > There's no DATEDIFF in Oracle. But you can create a function that
> > equates.
> >http://msdn2.microsoft.com/en-us/lib...9(SQL.80).aspx
>
> >http://asktom.oracle.com/tkyte/Misc/DateDiff.html
>
> You can also use the minus (-) operator.
> --
> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

But some people need functions...