hi
In access I can make a query (1) that returns something
and make another query (2) that uses the first query (1).
How I can do it in Oracle 11g ?
thanks in advance
+3
A:
I am not an expert in Oracle but you should check out Views and Nested Views in Oracle.
Ender
2010-01-12 21:03:38
can i get sample for nested views ?
Gold
2010-01-12 21:37:32
A nested view is just a view that queries another view - in Oracle views can be queried as if they were ordinary tables.
Jeffrey Kemp
2010-01-13 06:33:22
+1
A:
In lack of more information about what to achieve, see the syntax of
Peter Lang
2010-01-12 21:22:27
+1
A:
Not sure what your question is, but you can use the WITH clause to create "views" within a query - no need to create a VIEW and in 11g you can use recursive sub-query using the WITH clause.
Stellios
2010-01-13 00:30:13