OraFAQ Forum: SQL & PL/SQL » ALL,ANY,SOME operators

Home » SQL & PL/SQL » SQL & PL/SQL » ALL,ANY,SOME operators

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

ALL,ANY,SOME operators [message #607102]

Mon, 03 February 2014 00:12

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

Thank You BlackSwan.

I have another question on ALL,ANY,SOME operators in oracle , can you please eloborate me.I searched on the Google I am very confusing , i thought all are worked same.

Thank You

[SPLIT from ORA-00923: FROM keyword not found where expected error by LF]

[Updated on: Mon, 03 February 2014 00:56] by Moderator

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607104 is a reply to message #607102]

Mon, 03 February 2014 00:17

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What exactly do you not understand? Could you, please, elaborate so that someone might try to help you understand?

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607106 is a reply to message #607102]

Mon, 03 February 2014 00:25

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Please, create a new topic for a new question.

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607107 is a reply to message #607104]

Mon, 03 February 2014 00:27

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

How the both queries worked? Please explain brief..

SQL> SELECT *
  2      FROM emp
  3      WHERE sal> any (2000, 3000, 4000)
  4  /

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7788 SCOTT      ANALYST         7566 09-DEC-82       3000                    20
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20

6 rows selected.

SQL> SELECT *
  2      FROM emp
  3      WHERE sal> all (2000, 3000, 4000)
  4  /

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7839 KING       PRESIDENT            17-NOV-81       5000                    10

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607108 is a reply to message #607106]

Mon, 03 February 2014 00:29

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

I am Sorry Michel Cadot,i posted just you sent , not do the next time.. Smile

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607109 is a reply to message #607107]

Mon, 03 February 2014 00:36

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Please explain brief

From the English dictionary
ANY: refer to one of a number of things or people, when it does not matter which one.
ALL: the whole number of.

[Updated on: Mon, 03 February 2014 00:37]

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607112 is a reply to message #607109]

Mon, 03 February 2014 00:41

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

Quote:

ANY: refer to one of a number of things or people, when it does not matter which one.
ALL: the whole number of.

This is related to exists condition ,right? Worked same as exists condition right?

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607120 is a reply to message #607112]

Mon, 03 February 2014 01:37

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

What is your opinion?
Do you think Oracle will change the meaning of the words for each statement?
You can always refer to Database SQL Reference.

Report message to a moderator

Previous Topic:	seperate out the string occured between particular characters
Next Topic:	Substring on digit in a character expression gives ORA-1722

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 13:08:17 CDT 2024