tag:blogger.com,1999:blog-2257062243512934022.post5412536138871762693..comments2023-10-31T18:51:23.836+05:30Comments on Sachin Arora's Blog: IN Vs Exist in SQLSachinhttp://www.blogger.com/profile/04551992629821526364noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-2257062243512934022.post-87154124106485195222013-01-10T16:35:54.570+05:302013-01-10T16:35:54.570+05:30Abhinav Narayan
it is of good help.Abhinav Narayan <br /><br />it is of good help.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-62745246378168997742011-02-04T21:00:29.639+05:302011-02-04T21:00:29.639+05:30Nice description. And one thing where to best use ...Nice description. And one thing where to best use in and exists.Developer Knowledge Househttps://www.blogger.com/profile/00414254017281760161noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-6839918185284634192010-06-28T15:17:46.525+05:302010-06-28T15:17:46.525+05:30Hello Sachin,
The explaination by you is very eas...Hello Sachin,<br /><br />The explaination by you is very easy and nice to understand.<br /><br />Regards,<br />Sachin.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-26015342987330807822009-09-10T14:50:54.801+05:302009-09-10T14:50:54.801+05:30Nice Explanation. Bookmarked :)
The original artic...Nice Explanation. Bookmarked :)<br />The original article was not as clear as yours for me..Unknownhttps://www.blogger.com/profile/11263497277662588776noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-64387693513709479722008-11-27T21:05:00.000+05:302008-11-27T21:05:00.000+05:30in fact the limit is 1000.ORA-01795: maximum numbe...in fact the limit is 1000.<BR/>ORA-01795: maximum number of expressions in a list is 1000<BR/><BR/><BR/>I enjoy the explanation on this error :<BR/>http://ora-1795.ora-code.com/<BR/>talking about 256 column.. when this is not related....Pedro Cristianhttps://www.blogger.com/profile/15122124776417709417noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-13974547493970011862008-07-18T10:22:00.000+05:302008-07-18T10:22:00.000+05:30The limit is on a String based IN statement (i.e. ...The limit is on a String based IN statement (i.e. "SELECT * FROM tbl_a A WHERE A.id IN (0001, 0002 ... 0501)")Timothy Chunghttps://www.blogger.com/profile/07177373643571096835noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-25049645611783295692008-07-18T09:25:00.000+05:302008-07-18T09:25:00.000+05:30I recall one of my colleagues telling me that ther...I recall one of my colleagues telling me that there is a item limit (500) on "IN" statement for Oracle 9i.<BR/><BR/>You can have a test on your DBMS. Hope it helps. :-)Timothy Chunghttps://www.blogger.com/profile/07177373643571096835noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-27099951940388276892008-05-20T15:38:00.000+05:302008-05-20T15:38:00.000+05:30A good explanation about differences between exist...A good explanation about differences between exists and inPKShttps://www.blogger.com/profile/09377601808498822521noreply@blogger.comtag:blogger.com,1999:blog-2257062243512934022.post-51718964547354596852007-10-18T18:14:00.000+05:302007-10-18T18:14:00.000+05:30yes, It's very nice explanations.yes, It's very nice explanations.Askvennelahttps://www.blogger.com/profile/16435186672037154096noreply@blogger.com