Home » SQL & PL/SQL » SQL & PL/SQL » SQL Non Equi Join (Oralce 9i)
SQL Non Equi Join [message #395889] Fri, 03 April 2009 00:14 Go to next message
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.
Re: SQL Non Equi Join [message #395894 is a reply to message #395889] Fri, 03 April 2009 00:25 Go to previous messageGo to next message
Frank
Messages: 7880
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.
Re: SQL Non Equi Join [message #396469 is a reply to message #395894] Mon, 06 April 2009 20:20 Go to previous messageGo to next message
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
Re: SQL Non Equi Join [message #396471 is a reply to message #395889] Mon, 06 April 2009 20:30 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
<>
like
NOT functions
field +constant
field || ''
Re: SQL Non Equi Join [message #396487 is a reply to message #396469] Mon, 06 April 2009 23:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Explain why you are not satisfied.

Regards
Michel
Re: SQL Non Equi Join [message #396773 is a reply to message #396487] Wed, 08 April 2009 00:53 Go to previous messageGo to next message
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.
Re: SQL Non Equi Join [message #396782 is a reply to message #396773] Wed, 08 April 2009 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: SQL Non Equi Join [message #396870 is a reply to message #395889] Wed, 08 April 2009 04:09 Go to previous message
flyboy
Messages: 1832
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.
Previous Topic: DROP SORT ROLLBACK inquiries
Next Topic: DBMS_SCHEDULER - job to be created
Goto Forum:
  


Current Time: Fri Dec 09 01:49:03 CST 2016

Total time taken to generate the page: 0.12118 seconds