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
- 10263 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
What is the difference between left join and right join?
Why do we need pl sql?
What is on delete restrict?
Explain what is a field in a database and record in a database?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How do you modify a trigger?
Which language is used in sql?
what is an alias command? : Sql dba
Can you have more than one key in a database?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What version is sql?
how to select first 5 records from a table? : Sql dba
Why do we use procedures?
Is there any restriction on the use of union in embedded sql?
how would you get the current date in mysql? : Sql dba
