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
- 10441 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 innodb? : Sql dba
Is sql similar to python?
What are all the ddl commands?
What are the different types of triggers?
What is the difference between inner join and outer join?
What does the file extension accdb stand for?
difference between anonymous blocks and sub-programs.
What found sql?
who introduced sql?
Show the two pl/sql cursor exceptions.
How to raise user-defined exception with custom sqlerrm ?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Should I use mbr or gpt?
What is a database? Explain
what are the different type of normalization? : Sql dba
