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
- 7743 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 implicit cursor in pl sql?
what is oracle database ? : Sql dba
What are the types of join and explain each?
What are the different schemas objects that can be created using pl/sql?
What is the difference between pl and sql?
what is sp_pkeys? : Transact sql
Write the command to remove all players named sachin from the players table.
What is group by in sql?
How to get unique records from a table?
what does the t-sql command ident_current does? : Transact sql
what is a field in a database ? : Sql dba
What is the use of & in pl sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What is the purpose of the partition table?
Name the different types of indexes in sql and define them.
