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
Is drop table faster than truncate?
Why trigger is used in sql?
How many types of index are there?
What is the difference between clustered and non-clustered indexes?
Does group by remove duplicates?
What is delimiter sql?
What do you understand by exception handling in pl/sql?
What do you mean by query optimization?
Can we create index on primary key?
Is sql a dbms?
What are the different types of constraints?
what is cross join? : Sql dba
What is the difference between left and left outer join?
How to run pl/sql statements in sql*plus?
how to fetch common records from two tables? : Sql dba