Interested to Buy Any Domain ? << Click Here >> for more details...
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 the difference between the conventional and direct path loads? : aql loader
discuss about myisam key cache. : Sql dba
What is the use of count (*) in sql?
How can you load microsoft excel data into oracle? : aql loader
Is not equal in sql?
what is the difference between char_length and length? : Sql dba
Can we use view in stored procedure?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
what tools available for managing mysql server? : Sql dba
How many types of indexes are there in sql?
What is the maximum database size for sql express?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is a parameter query?
Which data dictionary views have the information on the triggers that are available in the database?
Can we create index on primary key?
