alter table table_name add c4 varchar2(30) default null

I have one table and column is c1 pk, c2 not null,c3 not
null and 200 row in it and i add c4 column and value, how
can is possible

Question Posted / premraj

Answer Posted / premraj

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are wild cards used in database for pattern matching ? : Sql dba

1075

What is the usage of the distinct keyword?

1162

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1023

How do I find duplicates in two columns?

1054

What is the difference between left join and right join?

887

Explain exception handling in pl/sql?

987

Why partition by is used in sql?

963

How to find 3rd highest salary of an employee from the employee table in sql?

1034

what is a field in a database ? : Sql dba

986

how to load data files into tables with 'mysqlimport'? : Sql dba

1031

Does mysql_real_escape_string prevent sql injection?

906

What is sql entity?

1027

Can you have more than one trigger on a table?

939

Can we use pl sql in sql server?

1008

How can we avoid duplicating records in a query?

917