Home » SQL & PL/SQL » SQL & PL/SQL » i had a doubt
i had a doubt [message #434859] Fri, 11 December 2009 05:45 Go to next message
bnataraja
Messages: 2
Registered: December 2009
Location: Chennai
Junior Member
hi friends,
Thanks in advance. when and why we use (in). whether in is used as operator or not
Re: i had a doubt [message #434860 is a reply to message #434859] Fri, 11 December 2009 05:50 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

"IN" is a comparison operator, read the documentation

[Updated on: Fri, 11 December 2009 05:50]

Report message to a moderator

Re: i had a doubt [message #434861 is a reply to message #434859] Fri, 11 December 2009 05:51 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database SQL Reference
Chapter 7 Conditions
Section IN Condition

As I see in your profile your interest is in readings I encourage you to read the whole book.

Regards
Michel

[Updated on: Fri, 11 December 2009 05:52]

Report message to a moderator

Re: i had a doubt [message #434862 is a reply to message #434859] Fri, 11 December 2009 05:53 Go to previous messageGo to next message
delna.sexy
Messages: 941
Registered: December 2008
Location: Surat, The Diamond City
Senior Member
When we have multiple choices to choose from, it is comfortable to use IN clause, instead of OR, like this OR this OR this OR...

Why don't you google?

regards,
Delna
icon12.gif  Re: i had a doubt [message #434878 is a reply to message #434862] Fri, 11 December 2009 07:07 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member

IN is just a shortcut for: {something} like this OR this OR this OR...
Razz
Re: i had a doubt [message #434879 is a reply to message #434878] Fri, 11 December 2009 07:10 Go to previous messageGo to next message
Michel Cadot
Messages: 63806
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what does this add to the previous answers?

Regards
Michel
Re: i had a doubt [message #434881 is a reply to message #434878] Fri, 11 December 2009 07:12 Go to previous message
bnataraja
Messages: 2
Registered: December 2009
Location: Chennai
Junior Member
thanks for your help
Previous Topic: Writable materialized view with a custom column (merged)
Next Topic: How to select data(first 10 charcters) from a LONG datatype column.?
Goto Forum:
  


Current Time: Wed Sep 28 07:30:37 CDT 2016

Total time taken to generate the page: 0.10505 seconds