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 double ampersand (&&) in sql queries? Give an example
What are the basic techniques of indexing?
How can you load multi line records? : aql loader
What is right join in sql?
How do I partition in sql?
What does varchar include?
How many types of normalization are there?
how to use myisamchk to check or repair myisam tables? : Sql dba
What are types of exception?
Can you join a table to itself?
Explain the steps needed to create the scheduled job?
What is the starting oracle error number?
What is a boolean in sql?
How do you declare a constant?
Which is better trigger or stored procedure?