Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between simple view and complex view?
- 13 Answers
- 53726 Views
- I also Faced
- E-Mail Answers
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
Explain a synonym?
what is the difference between restoring and recovering?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What is the use of aggregate functions in oracle?
Why do you create or replace procedures rather that drop and recreate.
How to connect the oracle server as sysdba?
What are group functions in oracle?
What do you mean by a tablespace?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
how to join query for one source type is oracle another source type is sql server ?
How to write an inner join with the where clause in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What are the four Oracle system processes that must always be up and running for the database to be useable?
what is normalisation?what are its uses?
What is a sub query and what are the different types of subqueries?
