0
1. create table vi(n number);
insert into vi(1);
insert into vi(2);
insert into vi(3);
insert into vi(4);
2. create table bh(n number, name varchar2(10));
insert into bh(1, 'vij1');
insert into bh(2, 'vij2');
insert into bh(3, 'vij3');
insert into bh(4, 'vij4');
create view v1 as select vi.n, bh.name from vi, bh wherer vi.n=bh.n;
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
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 complex view in oracle?
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.
When was Oracle Complex MRO created?
Oracle Complex MRO was created on 1985-11-20.
What is the definition of view oracle database?
I want to know how the view is working in oracle?
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.
Can word processor create a database?
No. A database is much more complex then a document. You need a database program to create a database. If your needs are not too complex, Microsoft Access is a decent low end database. If you need something powerful, Oracle is much better, but you'll pay for it.
Why must create database in oracle?
gfhgfhgfhjgfjghk
What is the difference between oracle and oracle?
Oracle is one of the popular database and DBA (DataBase Administrator) is the person who maintain the database (install oracle software, create,setup,maintain database)
How can one create tables in Oracle?
If one is wanting to create a table in Oracle one must use the "Create Table" statement. These tables are partially defined by the columns contained and the information in the column. One must first decide the proper column type and then these data types are used in the Create Table statement. One must be somewhat familiar with Oracle in order to create these tables and additional information can be found on the DBA-Oracle website.
Is the relational database an example of oracle database?
A relational database is a type of database design. Oracle is a brand of database. You can create a relational database using Oracle. You can also create relational databases using other database applications.
How do you create an Excel to Oracle converter?
From MS Excel, there is nothing you can create. You can save an Excel file in various formats, that might make it easier to import the data into Oracle.
What are the components of oracle database?
DDL - Data Definition Language Create,Alter,Drop and Truncate are the components of oracle database.
