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

How does an execution block start and end in pl sql?

502

what is the difference between join and union? : Sql dba

552

Is the primary key an index?

599

What are %type and %rowtype for?

619

What are the possible values that can be stored in a boolean data field?

517

What is dynamic sql in pl sql?

498

What is a subquery in sql?

512

What are the indexing methods?

579

Is json a nosql?

541

What is blind sql injection?

578

Why do we go for stored procedures?

527

explain primary keys and auto increment fields in mysql : sql dba

537

How do you modify a table in sql?

571

What do you mean by rowid?

540

What language is oracle sql developer?

510