Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 7847 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is a null value?
How do I make my sql query run faster?
Is sql harder than python?
What is a memo field?
What is replication id?
How to rename a column in the output of sql query?
What does closing a cursor do?
how to get @@error and @@rowcount at the same time? : Sql dba
What is pls_integer in pl sql?
What's the difference between a primary key and a clustered index?
What do you mean by stored procedures?
How do you break a loop in pl sql?
how to concatenate two character strings? : Sql dba
What is the trigger in sql?
Will truncate release space?
