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 / manoj
1.
alter table <table_name>
add column<col_name> <data_type>[not null];
2.
for inserting values
Depends: if u have data in another table than u can insert
by making small packege (using cursor)
OR :u can also sequence to insert
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the use of %rowtype?
What has stored procedures in sql?
What are different types of keys?
what are the advantages and disadvantages of views in a database? : Sql dba
How many triggers can be applied on a table?
Can we use pl sql in mysql?
Which operator is used in query for pattern matching?
What is trigger types in sql?
Is primary key an index?
Can 2 queries be executed simultaneously in a distributed database system?
What is using in sql?
what are the advantages of sql ? : Sql dba
What is primary key secondary key alternate key candidate key?
Why do we use sqlite?
What is the purpose of the primary key?