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 are string functions in sql?
Enlist the characteristics of pl/sql?
What does := mean in pl sql?
What normalization means?
Why do we use procedures in pl sql?
What is trigger in pl sql with examples?
What is file based approach?
what is top in tsql? : Transact sql
What does dml mean?
Explain unique key in sql.
What is self-join and what is the requirement of self-join?
What is pl sql record in oracle?
What does rownum mean in sql?
What is Difference Between Unique and Primary Key Constraints?
What is error ora-12154: tns:could not resolve the connect identifier specified?