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
- 7841 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 |
Which sorts rows in sql?
Does postgresql run on the cloud?
A table has 150 records. How do you retrieve 100th row to 120th row from that table ?
Can we perform dml in function?
How can I create a table from another table without copying any values from the old table?
What is %type in sql?
what is the difference between myisam static and myisam dynamic? : Sql dba
what is the order of pre-defined exceptions.
What does “select count(*) from tab” result?
15 Answers IBM, Student, Wipro,
What is set transaction?
Why is nosql good?
What are indexes, and what are the different types?
-
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)
