To insert a record into a table, you must specify values for all fields that do not have default values and cannot be
The second line of the above statement can be excluded if all required columns are inserted and the values are listed in the same order as the columns in the table. We recommend you include the second line all the time though as the code will be easier to read and update and less likely to break as the database is modified.
In the presentation that follows, the instructor states that the record ID is auto-generated by SQL when a record is inserted. While this is true for SQL Server and MySQL, it is not true for Oracle. In Oracle, an INSERT requires that the user specify a record ID. Therefore, this is an additional difference in addition to the date format between the three databases.