1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

if i perform any operation on views such as insert, delete
etc will my base table get affected?????

Question Posted / guest

Answers were Sorted based on User's Feedback



if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / ramesh

yes if it is simple view. error if it is compunt view

Is This Answer Correct ?    8 Yes 2 No

if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / gourvendra singh

It will affect ur base table only when u having a simple
view and if you put null in the field which is primary key
of the base table then also the base table will not
affected. And if you are using the compute view then u r nt
able to insert or delete the records.

Is This Answer Correct ?    3 Yes 1 No

if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / slokh

yes if it is a simple view. may be if is a complex view -

Is This Answer Correct ?    0 Yes 0 No

if i perform any operation on views such as insert, delete etc will my base table get affected????..

Answer / 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

More SQL PLSQL Interview Questions

How do you truncate?

0 Answers  

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

What does fetching a cursor do?

0 Answers  

1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...

0 Answers   Satyam,




What is dml and ddl?

0 Answers  

Where the integrity constrints are stored in Data Dictionary?

1 Answers  

what is self join and why is it required? : Sql dba

1 Answers  

How many sql are there?

0 Answers  

Does google use sql?

0 Answers  

Does group by remove duplicates?

0 Answers  

Is left join faster than inner join?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories