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

a. Can you delete data from a View.
b. If Yes, can you delete it if there are multiple tables
c. If No, can you delete if there is single source table
which is joining.

Question Posted / sql2000


a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. ..

Answer / barun

A.Yes we can delete data from view.actually we deleting
data from crrospondind tabls or tables data by which view
is created.
b.if view is create by multi table then some condition
oracle follow-
1.if view contain group by,distinct then we cant delete
data.
2.if table contain colume data function or calculation we
can't.
3.if table contain not null value we can't delete.

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More SQL PLSQL Interview Questions

What is materialized view. What are different methods of refresh?

0 Answers  

What are different types of sql?

0 Answers  

How to test for null values?

0 Answers  

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

What are the different sql commands?

0 Answers  




How to process query result in pl/sql?

0 Answers  

Can you call pl/sql package functions from within a fast formula?

0 Answers  

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

Is there a 64 bit version of ssms?

0 Answers  

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

What packages(if any) has oracle provided for use by developers?

1 Answers  

What is trigger types of trigger?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories