inserting a new column to an existing oracle table with a fixed value in all the rows of that column

[Moieen Khatri]

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!

[v krish]

By setting a default value

alter table
TEST_DOCBASE
add
docbase varchar(15) DEFAULT 'ABC' ;

[Moieen Khatri]

Thanks for the reply!

The issue is now resolved.

How can I delete a table?

Thanks

[Jeanne Boyarsky]

Moieen Khatri wrote:Thanks for the reply!

The issue is now resolved.

How can I delete a table?

Thanks

drop table_name;