What are the different types of Views?

Answer Posted / radharaman

There are two types of view in oracle.
1. Simple view
2. Complex view

Simple view is a view which retrives data from one base table and complex view can contain two or more table and can contain functions and group by.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can a domain, assigned to a data element be changed?

628


What are the personnel administration related Infotypes

2060


What is the difference between leave transaction and call transaction?

609


Program lines for the radio button selection and unabling some input variables in section screen

913


What is the disadvantage of a call by reference?

639






How do you write a function module in sap?

616


wht is the diff. b/n initialization and lotus of event

1393


What is off cycle payroll run

1784


To how many tables can an append structure be assigned. : abap data dictionary

590


What are logical databases? What are the advantages of logical databases?

522


Write syntax for message error (report)?

635


what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.

2060


What are the list of screen elements?

528


Why do we use FOR ALL ENTRIES and what is the pre-requisite

922


Have you processed BDCs ?

627