OraFAQ Forum: Test

Home » Other » Test » Testing

Tue, 12 February 2008 01:04

manjukini
Messages: 1
Registered: November 2007

Junior Member

SQL> SELECT * FROM emp WHERE EXISTS
2 (select * from dept where dept.deptno = emp.deptno);

Tue, 12 February 2008 01:25

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You fail in using [code][/code] tags like this:

SQL> SELECT * FROM emp WHERE EXISTS
2    (select * from dept where dept.deptno = emp.deptno);

which has been written:
[code]SQL> SELECT * FROM emp WHERE EXISTS
2 (select * from dept where dept.deptno = emp.deptno); [/code]

Regards
Michel

[Updated on: Tue, 12 February 2008 01:26]

Tue, 12 February 2008 05:00

varu123
Messages: 754
Registered: October 2007

Senior Member

YOu failed to use SQL FORMATTER

SELECT *
FROM   emp
WHERE  EXISTS (SELECT *
               FROM   dept
               WHERE  dept.deptNo = emp.deptNo);

Previous Topic:	xyant
Next Topic:	Newbie testing

Goto Forum:

]

Current Time: Thu Dec 26 18:47:55 CST 2024