DML Data Manipulation language

1.INSERT (insert) language structure

Insert into table (table name) (column name to insert)

Values (the specific value to insert);

Table: Tables name of the table to insert data into

Column[,column]: The name of the column in the table to insert data into

Value: The specific data value to insert in the corresponding column

Column name: Table (saledate) Shelf time

1. Corresponding: Value (sysdate) Current system time

2.value (to_date (' 2012-3-3 ', ' yyyy-mm-dd ')) a specific time

DML Data Manipulation language