Dovberman
asked on
Oracle Add a Column. Set Default Value to False
I have a table named TableA. I need to add a column named Delete_Me.
The new column needs a default value of false.
Which is a better datatype choice, VarChar2(1) or Number defaulted to 0 ?
What is the syntax for creating the new column?
Thanks,
The new column needs a default value of false.
Which is a better datatype choice, VarChar2(1) or Number defaulted to 0 ?
What is the syntax for creating the new column?
Thanks,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I think it's only available from Oracle 11.2, but not sure...
ASKER
Thanks
ASKER