Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

What are the operators used in select statements?

0 Answers  

What are the different sql commands?

0 Answers  

What is sorting in sql?

0 Answers  

I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....

3 Answers  

What is anonymous block in sql?

0 Answers  

What is a database? Explain

0 Answers  

Explain raise_application_error.

0 Answers  

what is global variable in package

3 Answers   Polaris,

What is the difference between row level and statement level trigger?

0 Answers  

what is meant by tuning and tk proof?

2 Answers  

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories