OraFAQ Forum: Performance Tuning » Difference between two query

Home » RDBMS Server » Performance Tuning » Difference between two query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Difference between two query [message #204309]

Mon, 20 November 2006 02:00

juliee_jitu
Messages: 8
Registered: July 2006

Junior Member

Hi,
Please tell me
Is there any thing difference between this two queries ?
as the result is coming same for both the query.

where can i use this query ??

SELECT   nme, dptname
    FROM emp LEFT JOIN dept ON emp.dpt_id = dept.dpt_id
ORDER BY nme DESC


SELECT   nme, dptname
    FROM emp, dept
   WHERE emp.dpt_id = dept.dpt_id(+)
ORDER BY nme DESC

The result -->

nme, dptname
=========================
bungle, sales
Rod, hr
NoDept,
Jane, hr
George, hr
Freddy, sales

[Updated on: Mon, 20 November 2006 02:04]

Report message to a moderator

Re: Difference between two query [message #204315 is a reply to message #204309]

Mon, 20 November 2006 02:25

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi Juliee,

Left Outer Join is ANSI standard sql.
and

*********************

(+) join is SQL*PLUS propertary.

http://awads.net/wp/tag/join

http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm#i2054012

hope this helps.
Taj.

Report message to a moderator

Re: Difference between two query [message #204467 is a reply to message #204309]

Mon, 20 November 2006 22:22

moparthy99
Messages: 13
Registered: July 2006

Junior Member

only diff is one ANSI sql and oracle

Report message to a moderator

Previous Topic:	Regarding parse_calls in v$sqlarea
Next Topic:	GATHER_SCHEMA_STATS - monitoring progress?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 04 02:23:42 CST 2025