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.
- 4 Answers
- 9675 Views
- CGI, IBM, I also Faced
- E-Mail Answers
Answer Posted / pankaj
you can remove the rows from the view if it does not containing any of the following.
1> group function
2> group by clause
3> distinct keyword
4> rownum keyword
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why stored procedure is better than query?
Can we use distinct and group by together?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
what is cross join? : Sql dba
Can we alter stored procedure?
How do I run a script in sql developer?
Why do we use sqlite?
How to run sql statements through the web interface?
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is the left table in sql?
Explain character-manipulation functions?
What is sql key?
What is left join in postgresql?
Are sql connections encrypted?
How are functions and procedures called in PL/SQL?
