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

how would you enter characters as hex numbers? : Sql dba

516


What is compiled query?

516


What is sql and how does it work?

545


What is an inconsistent dependency?

579


what is a materialized view? : Sql dba

571






What does cursor do in sql?

514


What is the basic form of sql query?

491


How to pipe multiline string to isql?

572


Where is all the data on the internet stored?

552


how can you see all indexes defined for a table? : Sql dba

537


What trigger means?

562


How does one load ebcdic data? : aql loader

643


How to check if a column is nullable before setting to nullable?

580


Will truncate release space?

514


How to combine two stored procedures in sql?

591