Results 1 to 5 of 5

Thread: Defferences in SQL syntax between MS Access, SQL Server and Oracle

  1. #1
    LiliDi Guest

    Defferences in SQL syntax between MS Access, SQL Server and Oracle

    Hi all,
    I have to prepare document what to explane differences in SQL syntax between MS Access, SQL Server and Oracle. I know quite well MS Access and SQL Server, but i don't know Oracle. Can someone help me with information about problem?
    Thanks in advance.

    LiliDi

  2. #2
    Neill Travers Guest

    Defferences in SQL syntax between MS Access, SQL Server and Oracle (reply)

    Hi,

    Some simple differences between SQL Server and Oracle (see SQL 7 Books Online and enter "Migrating Oracle" and a number of articles documenting the differences will be returned

    Briefly though:

    A CASE statement in SQL server has an equivalent statement called DECODE which is structured differently but has the same functionality

    Oracle has a MINUS and INTERSECTION clause for use in UNION queries.

    There is no ability in SQL server for hierarchial queries (a special query is available in Oracle using CONNECT BY PRIOR clause)

    If writing stored procedures, Transact SQL and it's Oracle equivalent PL/SQL have quite different syntax which are too many to document here.

    Hope this helps

    ------------
    LiliDi at 6/14/01 7:17:35 AM

    Hi all,
    I have to prepare document what to explane differences in SQL syntax between MS Access, SQL Server and Oracle. I know quite well MS Access and SQL Server, but i don't know Oracle. Can someone help me with information about problem?
    Thanks in advance.

    LiliDi

  3. #3
    Patrick Guest

    Defferences in SQL syntax between MS Access, SQL Server and Oracle (reply)

    HI LILIDI,

    A Swynk Columnist has already done this kind of work for you.

    On the left of this screen, you will see
    Ressources and below Columnists.===>Open columnists
    Then ===> Find 'Sergey Verdayan' (or near) then open
    and ===> find the comparaison articles, then open.
    Patrick


    ------------
    LiliDi at 6/14/01 7:17:35 AM

    Hi all,
    I have to prepare document what to explane differences in SQL syntax between MS Access, SQL Server and Oracle. I know quite well MS Access and SQL Server, but i don't know Oracle. Can someone help me with information about problem?
    Thanks in advance.

    LiliDi

  4. #4
    Join Date
    Jan 2009
    Posts
    1

    Not able to find the link

    Hi Patrick,

    I am not able to find Columnists under Resources. Even I want to know the differences between sql server and oracle. Please let me know the where the document is.

    Thanks in advance,
    Praveen

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •