Recent questions tagged view

2 votes

1 answer

View Creation
CREATE VIEW V AS(SELECT R1.A,R2.B FROM R AS R1, R as R2 WHERE R1.B=R2.A) Suppose the current contents of relation R A B 1 2 2 6 2 5 3 5 ------------------------------------------------------------------------------------------------------------------------ How to create view? Give some instances of it

CREATE VIEW V AS(SELECT R1.A,R2.B FROM R AS R1, R as R2 WHERE R1.B=R2.A)Suppose the current contents of relation RAB12262535 How to create view? Give some ins...

srestha

415 views

srestha asked Jul 15, 2018

0 votes

0 answers

Update, Delete and Insert via View in SQL
Hi Guys, In what situation Update, Delete and Insert operation could be performed via view ? Please provide some kind of proof to support your answer. It will be really helpful. PS: http://www.geekinterview.com/question_details/4529 ... modify-data-through-a-view http://www.sqlservercentral.com/blogs/sqldbauk/2011/07/11/can-you-delete-from-a-view_3F00_/

Hi Guys,In what situation Update, Delete and Insert operation could be performed via view ? Please provide some kind of proof to support your answer. It will be really he...

Chhotu

240 views

Chhotu asked Dec 11, 2017

To see more, click for the full list of questions or popular tags.

tags	tag:apple
author	user:martin
title	title:apple
content	content:apple
exclude	-tag:apple
force match	+apple
views	views:100
score	score:10
answers	answers:2
is accepted	isaccepted:true
is closed	isclosed:true