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
- 7842 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 |
Is clustered index a primary key?
What does fetching a cursor do?
What is the purpose of the primary key?
How to return multiple rows from the stored procedure?
how to enter characters as hex numbers? : Sql dba
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.
What is the maximum number of rows in sql table?
How long will it take to learn pl sql?
What is structural independence and why is it important?
How can we make an if statement within a select statement?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
-
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)
