1、單行插入
    insert into <tabler>[(column,[column,...])]values(value,[value,....])
    使用default 插入數(shù)據(jù)，在values當中使用default會插入默認值，或者NULL

2、使用字查詢插入數(shù)據(jù)。
      INSERT INTO <TABLE> subquery.

     INSERT ALL insert_into_clause [value clause]subquery
    INSERT conditional_insert_clause subquery

    insert all 
    when deptno = 10 then into dept10
    when deptno = 20 then into dept20
    else into others
     select * from emp;

      INSERT FIRST(如果先前的數(shù)據(jù)已經(jīng)被使用過，那么在后續(xù)當中則不會再使用這些數(shù)據(jù)) 
    when deptno = 10 then into dept10
    when deptno = 20 then into dept20
    else into others
     select * from emp;

另外提供create table as subquery;