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

2、使用字查詢插入數據。
      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(如果先前的數據已經被使用過，那么在后續當中則不會再使用這些數據) 
    when deptno = 10 then into dept10
    when deptno = 20 then into dept20
    else into others
     select * from emp;

另外提供create table as subquery;