CUSTID BUYMONTH NUM ---------- -------- ---------- 001 cc 1 001 cc 1 001 cc 3 002 cc 1 002 cc 1 003 cc 1
6 rows selected
SQL> desc t; Name Type Nullable Default Comments -------- ------------ -------- ------- -------- CUSTID VARCHAR2(10) Y BUYMONTH VARCHAR2(6) Y NUM NUMBER Y
SQL> select 'insert into t values('''||t.custid||''','''||t.buymonth||''','||t.num||');' from t;
'INSERTINTOTVALUES('''||T.CUST -------------------------------------------------------------------------------- insert into t values('001','cc',1); insert into t values('001','cc',1); insert into t values('001','cc',3); insert into t values('002','cc',1); insert into t values('002','cc',1); insert into t values('003','cc',1);
exp system/manager@conn_string owner=(test) file=d:\backup\test.dmp log=d:\backup\test.log buffer=655000
SQL> select * from t;
CUSTID BUYMONTH NUM
---------- -------- ----------
001 cc 1
001 cc 1
001 cc 3
002 cc 1
002 cc 1
003 cc 1
6 rows selected
SQL> desc t;
Name Type Nullable Default Comments
-------- ------------ -------- ------- --------
CUSTID VARCHAR2(10) Y
BUYMONTH VARCHAR2(6) Y
NUM NUMBER Y
SQL> select 'insert into t values('''||t.custid||''','''||t.buymonth||''','||t.num||');' from t;
'INSERTINTOTVALUES('''||T.CUST
--------------------------------------------------------------------------------
insert into t values('001','cc',1);
insert into t values('001','cc',1);
insert into t values('001','cc',3);
insert into t values('002','cc',1);
insert into t values('002','cc',1);
insert into t values('003','cc',1);
6 rows selected
SQL>