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
- 7754 Views
- CGI, I also Faced
- E-Mail Answers
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 |
What is an implicit commit?
What is sql procedures and functions?
difference between cursor and procedure in a package
what is data control language? : Sql dba
What types of commands can be executed in sql*plus?
what is an extent ? : Sql dba
Why self join is used in sql?
How to make a copy values from one column to another in sql?
how to install mysql? : Sql dba
What is meant by user defined function?
Explain autonomous transaction.
can a stored procedure call itself or recursive stored procedure? : Sql dba
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
