5 Replies Latest reply on Aug 15, 2014 8:29 PM by rp0428

    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.



      On oracle