INSERT 语句 ORACLE / MSSQL

Microsoft SQL Server                                              Oracle

                     Syntax:                                                   Syntax:

                      INSERT [INTO]                                     INSERT INTO [user.]{table |
                     [[database.]owner.] {table |                       view}[@dblink][(column [,
                     view}[(column [,                                      column]...)]{VALUES (expression [,
                     column]...)]{VALUES (expression           expression]...) | query...};
                     [,expression]...) | query}

                     描述:                                                                  描述:

                     INTO 可选.                                                    INTO 必须.

                     Inserts are allowed in a view provided    Inserts 仅仅可以在单表视图中  
                     only one of the base tables is
                     undergoing change.

 

                     Recommendations:

                     INSERT statements in Microsoft SQL Server or Sybase Adaptive Server must be
                     changed to include an INTO clause if it is not specified in the original statement.

                     The values supplied in the VALUES clause in either database may contain functions.
                     The Microsoft SQL Server or Sybase Adaptive Server-specific functions must be
                     replaced with the equivalent Oracle constructs.

                              Note:    Oracle lets you create functions that directly match most
                              Microsoft SQL Server or Sybase Adaptive Server functions.

                     Convert inserts that are inserting into multi-table views in Microsoft SQL Server or
                     Sybase Adaptive Server to insert directly into the underlying tables in Oracle.