Results 1 to 2 of 2

Thread: Oracle joins ?

  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: Oracle joins ?

    Hi,

    Will there be any output difference on the execution of the below two queries ?

    (1)

    SELECT *
    FROM test a,
    test1 b
    WHERE a.sno (+) = 1

    (2)

    SELECT *
    FROM test a,
    test1 b
    WHERE a.sno = 1

    Is there any difference in the above two queries ?

    Please advice,

    Thanks,
    Sam

  2. #2
    Join Date
    Jan 2004
    Location
    The Netherlands
    Posts
    421
    Allmost sounds like homework, but no there would be no difference...

    Regards

Posting Permissions

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