5 Replies Latest reply: Aug 15, 2014 3:29 PM by rp0428 RSS

    Reg: column with default value-

    ranit B

      Hi experts,

      a conceptual doubt:

      Suppose there is a table with 3 columns and for 3rd column, I want to have a default value clause such that wenever NULL value comes, it should insert the default value.

       

      I don't want to use Virtual Columns (might have some caveats and has several limitations.

       

      I tried altering table and adding default clause, but still the insert statement inserts a Null value.

      Any pointers ?

       

      Help much appreciated.

       

      Ranit.

      On oracle 11.2.0.2.0