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 / premraj

alter table table_name add c4 varchar2(30) default null

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the basic form of sql query?

503


Why do we use procedures?

529


What are dml commands?

540


what are the different index configurations a table can have? : Sql dba

581


How do you use join?

531






What is sql and also describe types of sql statements?

571


What are sql functions? Describe in brief different types of sql functions?

500


How would you pass hints to the sql processor?

537


What is a primary key called that is made up of more than one field?

805


How do you optimize a stored procedure query?

577


What is not in sql?

510


what are the type of locks ? : Sql dba

539


what is the difference between inner and outer join? Explain with example. : Sql dba

555


Can we create table inside stored procedure?

540


Explain cursor types?

592