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

Explain isolation levels. : Transact sql

0 Answers  

What are the modes of parameters that can be passed to a procedure ?

3 Answers  

how to convert numeric values to character strings? : Sql dba

0 Answers  

What is cte?

0 Answers  

Can we create table in function?

0 Answers  




Hi All, I am new to both this blog and technology. I was able to see a response for one of the questions on triggers as below. I would like to know why are we using " if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then" instead, can't we use " if sysdate = 'sunday' then". I can understand the use of "rtrim", but dont know y v r using to_char. I have seen this in many cases but did not get a convincible explaination. Please help me with this and do excuse if this question sounds silly. Thanks in advance...... create or replace trigger trg_sun before insert on <table name> begin if rtrim(to_char(sysdate,'day'))=rtrim('sunday') then raise_application_error(-20345,'no transaction in sunday'); end if; end trg_sun;

2 Answers  

can i give user defined exception in a package

2 Answers  

What is the meaning of disabling a trigger?

0 Answers  

What is query optimization in sql?

0 Answers  

What is multiple columns?

0 Answers  

Can triggers stop a dml statement from executing on a table?

0 Answers  

How to avoid using cursors?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories