hgriva1
Last Activity: Nov 6 '07, 12:58 PM
Joined: Oct 5 '07
Location:
-
Thanks for your reply amit.... -
Creating global temporary table on join condition
Hi,
Is there a way in which i can create a global temporary table based on join condition
eg:
scott@ISNS>CREA TE GLOBAL TEMPORARY TABLE x
2 AS
3 SELECT deptno,dname
4 FROM(
5 select e.deptno,d.dnam e
6 from emp e ,dept d
7 where e.deptno=d.dept no
8 MINUS
9 select d.deptno,d.dnam e
10 from dept d
11 )
12 ON...
No activity results to display
Leave a comment: