what is the difference between simple view and complex view?
Answer Posted / siva kumari
A view which is created by only one table is called simple
view.A view which is created by more than one table (joins
and subquires) is called complex view.
we can not use any group by functions in simple view but we
can use group by function in complex view.
we can perform DML through simple views but we can not
always perform DML through complex view.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What is the meaning of recursive hints in oracle?
what is normalisation?what are its uses?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How to define an oracle sub procedure?
How to increment dates by 1 in oracle?
Does oracle partitioning improve performance?
How to load excel data sheet to oracle database
Explain the use of grant option in imp command.
Can sub procedure/function be called recursively?
How to define an oracle cursor variable?
How to define a cusotmer as a supplier in ORACLE R12
Give the advantages and disadvantages of clusters.
How can we create the complete backup of data in the oracle.