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.
- 4 Answers
- 10394 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
Is sql between inclusive?
How do you delete duplicates in sql query using rowid?
What is the difference between the sql*loader and import utilities? : aql loader
Which join is like an inner join?
What is the difference between truncate and drop statements?
How do I find sql profiler?
How do I run a pl sql procedure in sql developer?
How to use distinct and count in sql query? Explain
what are the difference between clustered and a non-clustered index? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is the use of stored procedures?
What is the current version of postgresql?
What is inner join in sql?
What are the different dcl commands in sql?
What is identity column in sql server?
