Hi All,
I am new to Oracle.I have a
Java application which is mapped to the oracle table.
The table has about 500+ rows.I want to add a new column to this existing table with some fixed
string in all the rows for the new column.How can I do this?
alter table
TEST_DOCBASE
add
docbase varchar(15) ;
creates a column "docbase" with null values inside the column.I want a string to appear in all the rows instead of null.How can I modify the above query to print a string say "abc" in all the rows of the docbase column?
Thanks in advance!