OraFAQ Forum: SQL & PL/SQL » virtual table...

Home » SQL & PL/SQL » SQL & PL/SQL » virtual table...

Thu, 14 March 2002 22:48

jeya
Messages: 18
Registered: January 2001

Junior Member

hi..

can anyone explain about virtual table???
i know view is an example for virtual table.
is there any other examples??

Fri, 15 March 2002 00:16

rama krishna
Messages: 97
Registered: December 2001

Member

select * from (select * from emp) e
now the query in brackets is called virtual table,
we can use 'e' as table in the same sql statement....

Previous Topic:	Emergency
Next Topic:	Number Format???

Goto Forum:

]

Current Time: Thu Apr 18 00:46:09 CDT 2024