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

Answer Posted / asraf

ALTER TABLE DUMMY1 ADD (C4 VARCHAR2(100) DEFAULT 0)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Where is pl sql used?

521


what are different types of collation sensitivity? : Sql dba

562


What is Histogram?

1103


What is sql partition?

557


What are the types pl/sql code blocks?

612






What is hibernate and its relation to sql?

594


Which is better join or inner query?

522


What is the difference between union and union all command?

556


What are the two types of cursors in pl sql?

542


What is primary key sql?

546


What are the datatypes available in pl/sql ?

616


Can we use ddl statements in stored procedure?

699


Explain the order of sql statement execution?

615


What are the types of join in sql?

520


What are joins in sql?

541