Oracle
|
|
DEFAULT allows you to specify the default value to the column in Oracle.
Expression can include a constant, any SQL function except for those, which return a literal argument, a column reference or a nested function invocation.
Restrictions: expression cannot contain references to PL/SQL functions or to other columns, date constants that are not fully specified and pseudo columns LEVEL, CURRVAL, NEXTVAL, and ROWNUM.
|
IBM DB2
|
|
DEFAULT allows you to specify the default value to the column in DB2.
Expression can include a constant, a special register like CURRENT DATE, CURRENT TIME or CURRENT TIMESTAMP, CURRENT SCHEMA, USER and a cast function.
Restrictions: expression cannot contain the value of the DATALINK type, object identifier of a typed table, the data of the structured type.
|