Interested to Buy Any Domain ? << Click Here >> for more details...
if i perform any operation on views such as insert, delete
etc will my base table get affected?????
- 4 Answers
- 10763 Views
- I also Faced
- E-Mail Answers
Answer Posted / radha sri seshu.kolla
yes it will effect if your view is a simple view (eg:
create or replace view empview as select * from emp;) this
is called simple view. if you use any joins or if u create
view using more than two tables then it is called complex
view. in case of comlex view the database will not effect.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do I run a query in pl sql developer?
what is 'mysqlimport'? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
What is example of database?
Can we rename a column in the output of sql query?
Is sql port 1433 encrypted?
What are the 3 modes of parameter?
What are the types pl/sql code blocks?
Is it possible to update views?
How would you reference column values before and after you have inserted and deleted triggers?
what are the performance and scalability characteristics of mysql? : Sql dba
How to Execute a Package in PL/SQL.?
Explain the savepoint statement.
what are local and global variables and their differences? : Sql dba
what is difference between delete and truncate commands? : Sql dba
