if i perform any operation on views such as insert, delete
etc will my base table get affected?????
Answer Posted / ramesh
yes if it is simple view. error if it is compunt view
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is pl sql script?
What are hotfixes and patches?
What is a pl/sql block?
what is the difference between myisam static and myisam dynamic? : Sql dba
Which sql most popular?
what is the difference between nested subquery and correlated subquery?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the process of copying data from table a to table b?
Can a foreign key have a different name?
What is primary key and unique key?
Explain the uses of a database trigger?
How do I audit the sql sent to the server?
What is difference between sql and excel?
What are records give examples?
What is update query?