All brands support use of the DEFAULT keyword as a way of explicitly specifying the default value for a column.
Some brands provide additional ways to solve the problem.
The syntax for inserting a single row is consistent across all database brands.As a shortcut, you can omit the column list in an INSERT statement: of the columns in the table, and be mindful of the order of the values in the VALUES list; you must supply values in the same order in which the database displays columns in response to a SELECT * query.The DEPT_EAST table has already been created with the same structure (same columns and data types) as DEPT and is currently empty.Simply follow the INSERT statement with a query that returns the desired rows.That may not sound like too useful a thing now, but the MERGE statement represents a very powerful way to bring a database table into sync with an external source of data (such as a flat file feed from a remote system). The value for DEPTNO should be 50, DNAME should be “PROGRAMMING”, and LOC should be “BALTIMORE”.
The INSERT statement allows you to create new rows in database tables.You do not want to copy the rows, only the column structure of the table.When using Create Table As Select (CTAS), all rows from your query will be used to populate the new table you are creating unless you specify a false condition in the WHERE clause.In the solution provided, the expression “1 = 0” in the WHERE clause of the query causes no rows to be returned.Thus the result of the CTAS statement is an empty table based on the columns in the SELECT clause of the query.The query may be complex or simple, but ultimately you want the result to be inserted into another table.