Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53224 Views
- I also Faced
- E-Mail Answers
Answer Posted / v v
A Simple view selects from one table. A Complex view
selects from one or more tables.
Both can use group functions..
Simple view can perform DML..
But complex views can't perform DML on parent table: can
perform only in child table
| Is This Answer Correct ? | 7 Yes | 8 No |
Post New Answer View All Answers
What are data pump export and import modes?
Is oracle a relational database?
Explain a private synonyms?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to empty your oracle recycle bin?
Explain the use of indexes option in imp command.
How to turn on or off recycle bin for the session?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Explain an integrity constrains?
How many types of segments in Oracle?
Why is oracle database so popular?
How do I spool to a csv formatted file using sqlplus?
What is blob data type in oracle?
