INSERT Column Name « Insert Delete Update « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Insert Delete Update
  3. INSERT Column Name
1.Using the column list in INSERT command, include a column list after the table name.
2.The order of values in the VALUES clause matches the order in which the columns are specified in the column list
3.Specifying a Null Value for a Column
4.Including Double Quotes in a Column Value
5.INSERTING DATA CONTAINING APOSTROPHES
6.SELECT SPECIFIC COLUMNS
7.Changing column order
8.Use quotation in insert statement in PL/SQL