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
- 10580 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
Can we alter stored procedure?
Is the primary key an index?
Where not exists in sql?
Can you select everything, but 1 or 2 fields, without writer's cramp?
Which command is used to delete a trigger?
What is difference between nchar and nvarchar?
Why do we use function in pl sql?
what is data manipulation language? : Sql dba
How is indexing done in search engines?
What is multiple partition?
What is left join example?
What is raw datatype in sql?
What is Histogram?
What will you get by the cursor attribute sql%notfound?
What is linq to sql?
