what is wrong in the sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: what is wrong in the sql

Hybrid View

  1. #1
    Join Date
    Jun 2003
    Location
    India
    Posts
    118

    what is wrong in the sql

    Following query running properly in windows os but giving error in linux os. The error message is

    Ther version of Oracle is 8.

    'Sql command not ended properly.'

    select u.UWKZNO, u.UWKZNAME, d.AMOUNT, s.SUPPLIERNAME
    from INVOICE i
    join INVOICEDETAILS d on i.INVOICEID=d.INVOICEID
    join UWKZ u on u.UWKZID=d.UWKZID
    join SUPPLIER s on s.SUPPLIERID=i.SUPPLIERID
    where i.SEASONID=1 and i.ENTRYMONTH=1 and u.WKZID=1

    Thanks
    vishal sood
    OCP 8

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    "JOIN" in Oracle 8 ????
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    118
    yes this may be the problem. Because on windows OS we r having Oracle 9i(9.2.0) and on Linux we r having oracle 8i.(8.1.7).

    and on windows Os the same query is working fine.
    vishal sood
    OCP 8

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Originally posted by vishal sood
    yes this may be the problem. Because on windows OS we r having Oracle 9i(9.2.0) and on Linux we r having oracle 8i.(8.1.7).

    and on windows Os the same query is working fine.
    "JOIN" is avialable only in 9.x.x onwards...
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

Posting Permissions

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



Click Here to Expand Forum to Full Width