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

alter the table -> alter table <table name> <datatype>
after then u can insert values in that clounm bu using
UPDATE ...
update set column name= value where condition
condition ....where u want to update the value means which
row...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is drop table faster than truncate?

555


Why trigger is used in sql?

536


How many types of index are there?

554


What is the difference between clustered and non-clustered indexes?

605


Does group by remove duplicates?

553






What is delimiter sql?

548


What do you understand by exception handling in pl/sql?

579


What do you mean by query optimization?

552


Can we create index on primary key?

524


Is sql a dbms?

536


What are the different types of constraints?

566


what is cross join? : Sql dba

576


What is the difference between left and left outer join?

518


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

594


how to fetch common records from two tables? : Sql dba

633