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
- 7846 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 big data nosql?
what is a trigger in mysql? : Sql dba
What are secondary keys?
need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.
What is the maximum number of rows in sql table?
Are sql connections encrypted?
Do ddl statements need commit?
How do I run a pl sql procedure in sql developer?
What is sql not null constraint?
how to drop an existing index in mysql? : Sql dba
how to escape special characters in sql statements? : Sql dba
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
-
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)
