Altering a column to give it a default value
Hi there,
Stupid quesiton probably, but here we go: can someone tell me what the syntax is for adding a default value to a column?
I've tried various combinations along the lines of:
ALTER TABLE MyTable COLUMN myColumn SET DEFAULT 'foo'
...but no luck. Help!
Cheers,
Matt
http://www.matthewbarr.co.uk/
Subject
Written By
Posted
Altering a column to give it a default value
August 13, 2005 10:31AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.