Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9 Answers
- 11940 Views
- I also Faced
- E-Mail Answers
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 difference between function and procedure in pl/sql?
How do you declare a user-defined exception?
How do I start sql profiler?
Explain what is table in a database?
How do you respond to dementia behavior?
State some properties of relational databases?
What is mutating sql table?
What type of join is sql join?
what are sequences
What are the different dcl commands in sql?
What does the sign mean in sql?
How bulk collect improves performance?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What is the best sql course?
