if i perform any operation on views such as insert, delete etc will my base ta

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

Question Posted / guest

4 Answers
10614 Views
I also Faced
E-Mail Answers

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

What is the difference between inner join and outer join?

0 Answers

Does a join table need a primary key?

0 Answers

wht is the difference between sqlaserver2000 and 2005

1 Answers ABC, IBM,

What is the difference between jpql and sql?

0 Answers

Define implicit and explicit cursors.

0 Answers

What is user define exception and example

1 Answers HP, KP,

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

0 Answers

full outer join syntax

5 Answers

What is field delimiter?

0 Answers

package specification-3 procedures package body-2 procedures will is execute

2 Answers PWC,

declare v_count number(8,3); v_sal scott.emp.sal%type := '&P_sal'; cursor cur_name is select sal from scott.emp where sal between (v_sal-100) and (v_sal +1000); begin v_count :=nvl(sql%rowcount ,0); if v_count = 0 then dbms_output.put_line('no records are fetch in the given sal range'); else dbms_output.put_line('There is/are '||to_char(v_count)|| ' salaries are selected in the given range '); end if; end; in the above programm .....for any sal range ....always it shows the following message.. no records are fetch in the given sal range please find the mistake and share with me...with thansk and regards..sarao....

3 Answers Satyam,

What is database migration?

0 Answers

For more SQL PLSQL Interview Questions Click Here