Oracle clames that this is a MS standard, and NOT ANSI standard.
In Oracle is it not possible to create functions with "NULL parameter ()".
It is possible to create a "GetDate" function, but it must be called without
"()",
SELECT GETDATE, will then return the right value.
I think I have a BIG problem here.
Flemming
>They told you that isn't standard SQL? If you are talking about "SELECT
>GETDATE()," it's standard where I come from! Now, if you try a statement
>just as "GETDATE()," that will most likely fail because SQL doesn't
>understand GETDATE without SELECT or some other Action identifier. In fact,
>I'll check the SQL book right now! Alrighty, Oracle is not correct...I
>don't see how they can claim to support SQL if they don't know SQL's
>requirements! Here's what it says in the SQL Server 6.5 Developer Book:
>
>GETDATE
>The GETDATE function produces the current date and time in SQL Server
>Internal format for datetime values. GETDATE takes the NULL parameter ().
>
>To find the current system date and time:
>
>SELECT GETDATE()
>
>----------------------------------------------
>July 29 1995 2:50 PM
>
>And so on....It says it "takes the null parameter ()," which in my
>understanding of most of the SQL books, *needs* to be there to be fully
>compatible. Oracle customer support is wrong in this case, don't ya think?
>:) I apologize if I sound a bit heated, it's a been a comparable day with
>a couple other companies.
>
>----------
>From: Flemming Eriksen
>Sent: Wednesday, January 28, 1998 2:57 AM
>To: RadiusNT@iea-software.com
>Subject: Re: RadiusNt with Oracle
>
>Options Registry ?
>
>Oracle is running on a Unix Server, RadiusNT access Oracle thrue
>ODBC/SQL*Net.
>Oracle Customer Support telling me that "GetDate()" is not Standard SQL
>(ISO??)
>Is it possible to change RadiusNT's "GetDate()" to "GetDate" ?
>
>Flemming
>
>
>>Flemming Eriksen wrote:
>>>
>>> I am about to convert access database to Oracle, but inserting into
>CALLS
>is
>>> not possible.
>>> The problem is access use "GetDate()" and in Oracle I can't create a
>>> function that dosn't have a value inside "()".
>>>
>>> Do somebody have know what to do?
>>
>>You can add 16 to the Options Registry entry to have it act
>>like MS Access. I've been playing around with Oracle here and
>>trying to get RadiusNT to work with in (albeit 2.5). If people
>>think MS SQL Server is difficult to understand, they should
>>run from Oracle. Now I know what Oracle Admins get big bucks! :)
>>
>>--
>>Dale E. Reed Jr. (daler@iea.com)
>>_________________________________________________________________
>> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
>> Internet Solutions for Today | http://www.iea-software.com
>>
>> ----------------------------------------------------------
>> RadiusNT Mailing List lists@iea-software.com
>>
>
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>
>