Answer Posted / santosh kumar
Hi Friends,
This is Santosh Kumar, I just want to update one important
point in my answer that i missed before is
1. complex view cann't be updated always but by using
autonomous transaction in trigger we can update complex view
also........
thanks,
Santosh Kumar
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is embedded sql in db2?
What is mutating error in pl sql?
what is blob? : Sql dba
What are different types of sql commands?
Which join is default?
Explain the difference in execution of triggers and stored procedures?
what are the different index configurations a table can have? : Sql dba
Which sql statement is used to delete data from a database?
Mention what does plv msg allows you to do?
How we can update the view?
Can you sum a count in sql?
What is cursor explain with example?
What are the benefits of pl sql?
Does view store data in sql?
How do you create a db file?