answersLogoWhite

0

What is complex view in oracle?

User Avatar

Anonymous

12y ago
Updated: 8/20/2019

Where it's not simply limiting the columns or rows from a single table. A complex view would summarize/roll-up values in a table or join multiple tables together into the view.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How many types of view in oracle?

There are two types of views in Oracle based upon from how many tables data are being fetched. 1. Simple view - In this view, data is coming from only one table. 2. Complex view - In this view, data comes from more than one table. That's it. However, Complex views have some limitations. For these follow Oracle documentation.


What is the definition of view oracle database?

I want to know how the view is working in oracle?


When was Oracle Complex MRO created?

Oracle Complex MRO was created on 1985-11-20.


What is basic command of oracle?

SELECT, overall, I would view as most important.


How do you view users permissions in oracle database via sql query?

ask the DBA


What is a snapshot IN DBMS?

A DBMS snapshot in Oracle can also be referred to as a materialized view. Basically a snapshot is a refreshable view that can be refreshed on command or commit.


Where is the Oracle Arena located?

The Oracle Arena is an indoor arena located in Oakland sports complex in Oakland California. They are home to the Oakland Raiders, Oakland Athletics and Golden State Warriors.


What are modules of oracle?

Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement.


What is a view in oracle?

It is a a virtual table created for raw users on the sport eg:your atm reciept when you request for balance information


Where can one learn about sorting an IT asset inventory?

When looking to find further information in order to learn about sorting an IT asses inventory then it might be possible to view the Oracle assets user guide that is available from the Docs Oracle website.


What is the meaning of i in oracle 9i?

The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....The i in Oracle 8i and Oracle 9i stands for INTERNET....


Difference between Clintrial and oracle clinical software?

That is a complex question. Both are clinical data management systems used by hundreds of companies. Both products are now owned by Oracle. Clintrial is more modular and has separate tables for each trial where Oracle Clinical is more robust and has consolidated data. Both have numerous interfaces and add-on functionality. They are both Oracle Based and web enabled.