OraFAQ Forum: Server Administration » is there any EXISTS() in oracle

Home » RDBMS Server » Server Administration » is there any EXISTS() in oracle

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

is there any EXISTS() in oracle [message #57856]

Fri, 11 July 2003 06:02

sidd
Messages: 130
Registered: May 2003

Senior Member

in sql server there is an exists(), is there any funtion similar to exists() in oracle

Report message to a moderator

Re: is there any EXISTS() in oracle [message #57871 is a reply to message #57856]

Mon, 14 July 2003 02:15

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Yes there is:

  1  select ename
  2    from emp e
  3   where exists ( select d.deptno
  4                    from dept d
  5                   where d.deptno = e.deptno
  6*                    and d.dname like 'A%' )
SQL> /

ENAME
----------
CLARK
KING
MILLER

SQL>

HTH,
MHE

Report message to a moderator

Previous Topic:	Deliberately need ur Help
Next Topic:	indexes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:48:36 CDT 2024