I have one view which is derived from the table "A" and table"B". can i delete a row from this view? and after deleting what will be the data of table A and B?

  • Interview Candidate
  • 4
  • 2538

Showing Answers 1 - 4 of 4 Answers

Sachidanandan

  • Oct 19th, 2005
 

Answer:In complex view we cannot delete the table more than one by using the view concept.

DML operations cannot be done in complex view but it can be deleted by using simple view concept.

  Was this answer useful?  Yes

vamsi536

  • Nov 14th, 2005
 

Ya, It is true that that the DML concepts cannot be used in the complex views such as views containing JOINS. These can be applied to the views which are created on one table with a simple SELECT query.Any changes to this view changes the master table like(ADD,DELETE,UPDATE)

  Was this answer useful?  Yes

pjagannatha032

  • Feb 18th, 2006
 

the simple reason to this is DML operations can be done on a single table ,AND AS YOUR VIEW IS DERIVED FROM MORE THAN ONE TABLE ,SO IT IS NOT POSSIBLE TO DELETE.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions