If a View on a single base table is manipulated will the
changes be reflected on the base table?
Answer Posted / ehsraka
Yes, definitely. Since the view is based on a single table
and falls within the cateogory of simple view. Any change /
modification on the records will be reflected in the base
table.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is left join in sql?
Why primary key is required?
what are the types of join and explain each? : Sql dba
How do you go back in sql?
How do I count rows in sql?
What information is needed to connect sql*plus an oracle server?
What are the advantages of sql?
What is a system versioned table?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
Why is stored procedure faster than query?
What is the difference between having clause and where clause?
Write the alter statement to enable all the triggers on the t.students table.
What are all the different types of indexes?