Home » SQL & PL/SQL » SQL & PL/SQL » Query Generate an Error Pls Guide me Where I am Wrong (Windows server 2003)
Query Generate an Error Pls Guide me Where I am Wrong [message #574089] Mon, 07 January 2013 01:21 Go to next message
qanita786
Messages: 128
Registered: May 2007
Location: PAKISTAN
Senior Member
SELECT voc_no,voc_date
FROM sal_master LEFT OUTER JOIN godown_master
ON bill_no = voc_no

The Above Mentioned Query Generate The Following Error

1 SELECT voc_no,voc_date
2 FROM sal_master LEFT OUTER JOIN godown_master
3* ON bill_no = voc_no
SQL> /
FROM sal_master LEFT OUTER JOIN godown_master
*
ERROR at line 2:
ORA-00933: SQL command not properly ended

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574090 is a reply to message #574089] Mon, 07 January 2013 01:23 Go to previous messageGo to next message
Littlefoot
Messages: 16997
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Database version?

P.S. I mean, it is nice you mentioned your operating system version, but - why do you think that Windows Server 2003 is more important for LEFT OUTER JOIN than Oracle database version?

[Updated on: Mon, 07 January 2013 01:25]

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574092 is a reply to message #574089] Mon, 07 January 2013 01:26 Go to previous messageGo to next message
qanita786
Messages: 128
Registered: May 2007
Location: PAKISTAN
Senior Member
oracle 8.1.7

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574095 is a reply to message #574092] Mon, 07 January 2013 01:34 Go to previous messageGo to next message
Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ANSI joins were introduced in 9i in Oracle.

Regards
Michel

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574099 is a reply to message #574095] Mon, 07 January 2013 01:42 Go to previous messageGo to next message
qanita786
Messages: 128
Registered: May 2007
Location: PAKISTAN
Senior Member
How to make query in oracle 8.1.7 for examples i have two tables i compare table 1 to table 2 i want result from query all records display from table 1 which are exist in table 2 or not exist in table 2

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574101 is a reply to message #574099] Mon, 07 January 2013 01:44 Go to previous messageGo to next message
Littlefoot
Messages: 16997
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Use Oracle outer join syntax (+).

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574103 is a reply to message #574099] Mon, 07 January 2013 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On-line 8i documentation is available there
SQL Reference is there
And outer join are explained there

Try to apply it and come back with your solution or tries if you can't do it.

Regards
Michel

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574104 is a reply to message #574101] Mon, 07 January 2013 01:52 Go to previous messageGo to next message
qanita786
Messages: 128
Registered: May 2007
Location: PAKISTAN
Senior Member
when i use outer join the query show only those rows which are exist in both tables

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574105 is a reply to message #574099] Mon, 07 January 2013 01:54 Go to previous messageGo to next message
Littlefoot
Messages: 16997
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
qanita786 wrote on Mon, 07 January 2013 08:42
i have two tables i compare table 1 to table 2 i want result from query all records display from table 1 which are exist in table 2 or not exist in table 2


Then use [NOT] EXISTS (or even [NOT] IN).

[Updated on: Mon, 07 January 2013 01:54]

Report message to a moderator

Re: Query Generate an Error Pls Guide me Where I am Wrong [message #574107 is a reply to message #574104] Mon, 07 January 2013 01:57 Go to previous message
Littlefoot
Messages: 16997
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
qanita786 wrote on Mon, 07 January 2013 08:52
when i use outer join the query show only those rows which are exist in both tables


Faheem, did you apply for some kind of a contest? Lately, vast majority of your messages is useless for the rest of the community. How is anyone supposed to know what you got and why if you don't provide what you have and what query you applied to that input?

Report message to a moderator

Previous Topic: difference between oracle procedure & package
Next Topic: Removal of Special characters in a string
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 18:02:07 CDT 2013

Total time taken to generate the page: 0.99351 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.