Home » SQL & PL/SQL » SQL & PL/SQL » How Come There is No Error
How Come There is No Error [message #272763] Sun, 07 October 2007 03:05 Go to next message
ramit_mehra@infosys.com
Messages: 1
Registered: October 2007
Junior Member
select * from(select * from Employee);



this works absolutely fine.....

and shows all the records....what is the logic behind it?????
Re: How Come There is No Error [message #272777 is a reply to message #272763] Sun, 07 October 2007 05:38 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
There is no error, because it is a valid query.
You can use queries in your from-clause in Oracle.
Re: How Come There is No Error [message #272786 is a reply to message #272777] Sun, 07 October 2007 06:30 Go to previous messageGo to next message
tarmenel
Messages: 63
Registered: February 2007
Location: Israel
Member

This is the basis of how a view would work but instead of creating a separate view you use the brackets to create an "inner" view of sorts.
Re: How Come There is No Error [message #272831 is a reply to message #272763] Sun, 07 October 2007 23:33 Go to previous message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
This is called subquery. Read about subquery browse the document
http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96540/queries8.htm
Previous Topic: Servelet coding in Oracle 8i Vs Oracle 9i
Next Topic: problem with image (merged)
Goto Forum:
  


Current Time: Tue Dec 06 00:08:46 CST 2016

Total time taken to generate the page: 0.07970 seconds