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
Is sqlite good enough for production?
Can I learn sql in a week?
Mention what does plv msg allows you to do?
Can we join same table in sql?
how do you control the max size of a heap table? : Sql dba
What does over partition by mean in sql?
Explain unique key in sql.
What is data control language?
Does access use sql?
What is the difference between local and global temporary table?
What does t sql mean?
Why self join is used in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
how many sql ddl commands are supported by 'mysql'? : Sql dba
What is cross join sql?