Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Programming

 

Use PLSQL to insert data to table

SQL> SQL> CREATE TABLE department (   2  dept_id           INTEGER,   3  dept_name     VARCHAR2(32)); Table created. SQL> SQL> BEGIN   2  INSERT into department (dept_id, dept_name)values (1,'dept_name');   3  END;   4  / PL/SQL procedure successfully completed. SQL> SQL> select * from department;    DEPT_ID DEPT_NAME ---------- --------------------------------          1 dept_name SQL> drop table department; Table dropped. SQL>