Several ways that Oracle inserts table data

createtime--2018 February 5 11:42:15

Author:marydon

Several ways that Oracle inserts table data

1. Insert a whole row of data into the table

/*Method One*/INSERT  intoTable nameVALUES(Val1,val2,val3,...);/*Method Two*/INSERT  intoTable nameSELECTColumn1,column2,... fromTableWHEREForgid= '0', such as:INSERT  intoTempTableSELECT 1,2,3  fromDUAL;

Attention:

2. Insert the specified field data into the table

/* Method One */ INSERT  into VALUES (Val1,val2,val3,...); /* Method Two */ INSERT  into SELECT  from WHERE = ' 0 ';

3. BULK INSERT

INSERT  All  into TABLENAME  (COLUMN1, COLUMN2, COLUMN3, ...) VALUES   (?, ?, ?, ...)  into TABLENAME (COLUMN1, COLUMN2, COLUMN3, ...) VALUES   (?, ?, ?, ...)  into TABLENAME (COLUMN1, COLUMN2, COLUMN3, ...) VALUES   (?, ?, ?, ...)

Several ways that Oracle inserts table data