0
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 else can I help you with?
Will view drop if table drop?
If the dropped table is a base table for a view , then dbms like oracle invalidates these dependent views but does not drop them. But you cannot use these unless you re-create the table.
What are oracle skills?
You can tell the future if you have oracle abilities.
What is the most commonly used database application?
Oracle, MS SQL Server, Informix, Sybase, DB2, MySQL And for "toy" applications, MS Access.
How many types of registers?
registers are five types.
List out the dbms softwares?
*Altibase *Oracle * SQL server * Fox Pro * MS-Access * Sequel-Pro(mac)
What is the definition of view oracle database?
I want to know how the view is working in oracle?
What are the Other database types instead of oracle?
MsSqlServer
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 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
How many pages does Mallory's Oracle have?
Mallory's Oracle has 282 pages.
How many pages does Oracle Night have?
Oracle Night has 256 pages.
How many pages does Lady Oracle have?
Lady Oracle has 376 pages.
How many pages does Oracle's Queen have?
Oracle's Queen has 400 pages.
What are the different types of databases available?
sql db2 oracle mysql
What are 5 different types of databases?
sql db2 oracle mysql
What is the difference between oracle and oracle erp?
Oracle is a database corporation that has many products such as Database, BI and ERP
