Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Insert Update Delete

 

Insert into select

SQL> SQL> CREATE TABLE employee (   2  id          number,   3  name        varchar(100),   4  birth_date  date,   5  gender      varchar2(30) ); Table created. SQL> SQL> INSERT INTO employee (id,name,birth_date,gender )   2  SELECT 200,'Chris',NULL,'MALE' from   DUAL; 1 row created. SQL> SQL> drop table employee; Table dropped.