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.
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
Explain the update statement in sql
How many joins can you have in sql?
What does := mean in pl sql?
Explain the working of primary key?
what is a table in a database ? : Sql dba
How do I remove sql developer from windows 10?
What is pl sql architecture?
how to shut down the server with 'mysqladmin'? : Sql dba
How can a function retun more than one value in oracle with proper example?
Is not null in sql?
How do sql databases work?
I need a function for a train ticket reservation please answer it thanks in advance
Which are sql * plus commands?
what is heap table? : Sql dba
What is cartesian join in sql?