Home » Other » Test » Testing
icon12.gif  Testing [message #299437] Tue, 12 February 2008 01:04 Go to next message
manjukini
Messages: 1
Registered: November 2007
Junior Member
SQL> SELECT * FROM emp WHERE EXISTS
2 (select * from dept where dept.deptno = emp.deptno);
Re: Testing [message #299446 is a reply to message #299437] Tue, 12 February 2008 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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]

Report message to a moderator

Re: Testing [message #299509 is a reply to message #299437] Tue, 12 February 2008 05:00 Go to previous message
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 Mar 28 20:37:24 CDT 2024