Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Query on 2 table while exp and imp (Join)

Query on 2 table while exp and imp (Join)

From: peter <hhh.database_at_gmail.com>
Date: 5 Aug 2006 05:34:38 -0700
Message-ID: <1154781278.348945.276420@i3g2000cwc.googlegroups.com>


How can I exp the data where my following query is true:

select d.deptno,dname,ename,sal,address from dept d,emp e where d.deptno=e.deptno;

And Then how I imp the same data on client database in both tables. Received on Sat Aug 05 2006 - 07:34:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US