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 / shaik
u can alter the table. after that u can add the data
depending upon the criteria condition.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you explain an index number?
What is primary key secondary key alternate key candidate key?
When is a declare statement required?
What is function and procedure in pl sql?
What is varchar sql?
What found sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is nvarchar max in sql?
Advantages and disadvantages of stored procedure?
What is nosql vs sql?
what are myisam tables? : Sql dba
What is trigger point?
What is left join example?
What are pl sql procedures?
How do you optimize a query?