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
- 7821 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 |
How do I write a cron which will run a sql query and mail the results to agroup?
Can we use rowid as primary key?
Types of locks in database ?
When is the update_statistics command used?
What is cursor in pl sql?
How many commands are there in sql?
How to assign sql query results to pl sql variables?
what is denormalization. : Sql dba
what are all the different types of indexes? : Sql dba
How to raise user-defined exception with custom sqlerrm ?
Which command is used to delete a trigger?
What is Histogram?
-
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)
