can we update a view which is created from two tables
Answers were Sorted based on User's Feedback
Answer / guest
Yes , we can update a view which is based on more than one
table. And data will get updated in base tables also.
Is This Answer Correct ? | 21 Yes | 28 No |
What is the best sql course?
What is indexing in sql and its types?
What is form and report?
Does db2 use sql?
What is the advantage of index in sql?
what is definer rights invoke rights?
i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.
2 Answers IBM, Loginworks, OFSS,
Why indexing is needed?
Write the alter statement to enable all the triggers on the t.students table.
What are the packages in pl sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is input buffer in sql*plus?