How to set the default values in Oracle using Alter command?

Showing Answers 1 - 6 of 6 Answers

taraldesai
Profile Answers by taraldesai

Jun 23rd, 2007

specify parameter there is nothing like you are asking..
like
alter system set default ... wrong
alter system set sql_trace=TRUE;

rajakumar_na
Profile Answers by rajakumar_na

Nov 16th, 2007

Hi taraldesai!
Y Not?
Here is the example
Try this

ALTER TABLE table_name
ADD (column datatype DEFAULT expr);
(or)
ALTER TABEL table_name
MODIFY (column datatype DEFAULT expr)