generate dml

I just discovered that cool new function in SQL/Developer

just right click on the table and chose export sql insert


-- INSERTING into EMP
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7369
  ,'SMITH','CLERK',7902,to_date('1980-12-17',
  'DD-MON-RR'),800,null,20);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7499
  ,'ALLEN','SALESMAN',7698,to_date('1981-02-20',
  'DD-MON-RR'),1600,300,30);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7521
  ,'WARD','SALESMAN',7698,to_date('1981-02-22',
  'DD-MON-RR'),1250,500,30);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7566
  ,'JONES','MANAGER',7839,to_date('1981-04-02',
  'DD-MON-RR'),2975,null,20);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7654
  ,'MARTIN','SALESMAN',7698,to_date('1981-09-28',
  'DD-MON-RR'),1250,1400,30);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7698
  ,'BLAKE','MANAGER',7839,to_date('1981-05-01',
  'DD-MON-RR'),2850,null,30);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7782
  ,'CLARK','MANAGER',7839,to_date('1981-06-09',
  'DD-MON-RR'),2450,null,10);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7788
  ,'SCOTT','ANALYST',7566,to_date('1987-04-19',
  'DD-MON-RR'),3000,null,20);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7839
  ,'KING','PRESIDENT',null,to_date('1981-11-17',
  'DD-MON-RR'),5000,null,10);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7844
  ,'TURNER','SALESMAN',7698,to_date('1981-09-08',
  'DD-MON-RR'),1500,0,30);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7876
  ,'ADAMS','CLERK',7788,to_date('1987-05-23',
  'DD-MON-RR'),1100,null,20);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7900
  ,'JAMES','CLERK',7698,to_date('1981-12-03',
  'DD-MON-RR'),950,null,30);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7902
  ,'FORD','ANALYST',7566,to_date('1981-12-03',
  'DD-MON-RR'),3000,null,20);
Insert into "EMP" ("EMPNO","ENAME","JOB","MGR",
  "HIREDATE","SAL","COMM","DEPTNO") values (7934
  ,'MILLER','CLERK',7782,to_date('1982-01-23',
  'DD-MON-RR'),1300,null,10);

It is quite handy to post insert statements on forums, or move a table from one database to another just with copy paste, or export only a subset of the columns, because you can export a view too

4 thoughts on “generate dml”

  1. actually, it is not a bug 2050, it is a pure bug !


    Insert into “EMP” (“EMPNO”,”ENAME”,”JOB”,”MGR”,”HIREDATE”,”SAL”,”COMM”,”DEPTNO”) values (7369,’SMITH’,’CLERK’,7902,to_date(‘1980-12-17′,’DD-MON-RR’),800,null,20)
    *
    ERROR at line 1:
    ORA-01861: literal does not match format string

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>