OraFAQ Forum: SQL & PL/SQL » SQL Non Equi Join

Home » SQL & PL/SQL » SQL & PL/SQL » SQL Non Equi Join (Oralce 9i)

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

SQL Non Equi Join [message #395889]

Fri, 03 April 2009 00:14

ygsunilkumar
Messages: 100
Registered: August 2008

Senior Member

what are other operators allowed in the Non EquiJoins except these operators (<=, >=, BETWEEN)? It is an Interview Question.

Report message to a moderator

Re: SQL Non Equi Join [message #395894 is a reply to message #395889]

Fri, 03 April 2009 00:25

Frank
Messages: 7901
Registered: March 2000

Senior Member

IN, =, <, > are the first that come to my mind.
That is, after it came to my mind that the need to be able to sum up a complete list of operators is BS. I think the ability to explain what an equijoin is (or a non-equijoin) would be far more important.

Report message to a moderator

Re: SQL Non Equi Join [message #396469 is a reply to message #395894]

Mon, 06 April 2009 20:20

ygsunilkumar
Messages: 100
Registered: August 2008

Senior Member

Thanks for the answer but I didnot satisfy with answer. Please any one give me the correct answer

Report message to a moderator

Re: SQL Non Equi Join [message #396471 is a reply to message #395889]

Mon, 06 April 2009 20:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

<>
like
NOT functions
field +constant
field || ''

Report message to a moderator

Re: SQL Non Equi Join [message #396487 is a reply to message #396469]

Mon, 06 April 2009 23:20

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Explain why you are not satisfied.

Regards
Michel

Report message to a moderator

Re: SQL Non Equi Join [message #396773 is a reply to message #396487]

Wed, 08 April 2009 00:53

ygsunilkumar
Messages: 100
Registered: August 2008

Senior Member

like
field +constant
field || ''
how these can be used as non-equijoin operators? If yes, please give examples.

Report message to a moderator

Re: SQL Non Equi Join [message #396782 is a reply to message #396773]

Wed, 08 April 2009 01:11

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ygsunilkumar wrote on Wed, 08 April 2009 07:53

like
field +constant
field || ''
how these can be used as non-equijoin operators? If yes, please give examples.

Did you try to use them?

Regards
Michel

Report message to a moderator

Re: SQL Non Equi Join [message #396870 is a reply to message #395889]

Wed, 08 April 2009 04:09

flyboy
Messages: 1903
Registered: November 2006

Senior Member

ygsunilkumar wrote on Fri, 03 April 2009 07:14

what are other operators allowed in the Non EquiJoins except these operators (<=, >=, BETWEEN)? It is an Interview Question.

In my opinion, the easiest way to get this is:
Firstly, determine, which operator is used in equijoin.
Secondly, list all operators. As all the examples you listed are used in conditions, it is possible to find the rest of them in the Conditions chapter of SQL Reference. This documentation book is available e.g. online on http://tahiti.oracle.com/. Or, in an interview, you should ask the examiner what exactly he assumes to be an "operator".
Anyway, the last part is quite obvious.

Report message to a moderator

Previous Topic:	DROP SORT ROLLBACK inquiries
Next Topic:	DBMS_SCHEDULER - job to be created

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 19:41:23 CDT 2025