what is the difference between simple view and complex view?
Answer Posted / ramu c
A View is said to be simple view it should have a single
select statement only.Where as a complex view migh contain
select statement with joins, sub queries etc...
| Is This Answer Correct ? | 78 Yes | 13 No |
Post New Answer View All Answers
What is a nvl function?
How to call a stored function in oracle?
What are the different editions of oracle?
What is the dynamic sql in oracle?
how can we store any pdf file in oracle
Explain the use of show option in imp command.
Give the constructs of a package, function or a procedure.
How to convert times to characters in oracle?
What is raw datatype in oracle?
Hi Can any one tell me what are the API's used in requisition import.
Can you tell me how to add new column in existing views?how?How is possible?
What is the Tune Query
How to write an inner join with the where clause in oracle?
Explain what are clusters?
why dont we assign not null constraint as table level constraint.