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 / ravi singh

You can alter the table but u can not make the column as
null, and your insert statement will depends upon the
condition that u specified.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is error ora-03113: end-of-file on communication channel?

607


What is rtm stands for?

588


What is difference between left and right outer join?

528


What is the default isolation level in sql server? : Transact sql

570


What is the difference between delete, truncate and drop command?

554






What are the features of pl sql?

565


What is the cause of mutating table error and how can we solve it?

605


How do you declare a variable in pl sql?

535


How to run pl/sql statements in sql*plus?

594


Can procedure in package be overloaded?

614


What are the benefits of triggers?

606


Can we use the cursor's to create the collection in PL/SQL?

524


what is the difference between primary key and unique key? : Sql dba

533


What is example of database?

519


What is fmtonly in sql?

534