Home | Articles | Oracle Database | what is a View as object in oracle Views

what is a View as object in oracle Views

By
Font size: Decrease font Enlarge font

View is oracle objects that can be created by issuing a DDL "CREATE VIEW" Statement. A view can be basically defined as a projection of one or more tables. View has basic advantages and some disadvantages.At time no DML operation can be conduction on a view this depends on the type of view...To understand what is view read details....

Views are generally create by basic CREATE statement with a Query.

Eg . Create View View_Name as (Select colname1,colname2 from tablename)
The above statement creates a view by the name specified (VIEW_NAME). Such view which is a simple projection of one table is  created by using a simple select statement. In such view DML statement can work if its not voilating any integrating contraints of the TABLE on which  it is create and also the user has all the DML priveledges on the TABLE(if view created in different user)

Consider another example where view is created by issuing following Query Statement

Create View View_Name as (Select a.colname1,b.colname2 from tablename1 a, tablename2 b
where a.colname1=b.colname1)
The above view wich is a project of 2 tables and  will not permit any DML operation on the view .

 Consider another example where view is created by issuing following Query Statement

Create View View_Name as (Select count(colname) ,colname2 from tablename
Group by colname2
The above view which is again a projection of 1 table will not permit any DML operation on the view .

So To Conclude We can Say DML operation in a view cannot be performed if the view is based on more than one tables or if the view has some group functions used.

To create or to Over write an existing view use the command as
CREATE OR REPLACE VIEW VIEW_NAME AS (select ..........)

Other type of View are INLINE VIEW  which are not an object but a runtime view.

Subscribe to comments feed Comments (15 posted)

avatar
replica orologi 10/11/2015 06:05:18
The above view wich is a project of 2 tables and will not permit any DML operation on the view.
avatar
swiss replica watches 16/12/2015 13:55:10
Nice Post, And thx 4 ur share!
avatar
rolex replica watches 17/12/2015 12:02:32
Create View View_Name as (Select count(colname) ,colname2 from tablename
Group by colname2
avatar
Pepper 20/01/2016 21:14:14
Great article but it didn't have evtirehyng-I didn't find the kitchen sink!
avatar
Liberty 21/01/2016 02:47:50
I bow down humbly in the presence of such <a href="http://nkctfmtia.com">grnaetess.</a>
avatar
Veanna 03/02/2016 11:53:16
Ppl like you get all the branis. I just get to say thanks for he answer. http://wzrjwveq.com iyixyxmh [link=http://qqffaoedz.com]qqffaoedz[/link]
avatar
pay for essay 07/11/2016 16:50:12
This blog provided oracle article and database view is very important in oracle views. The details are all getting to find new topics and reviews for the users. So they can follow the steps to find more interesting points.
avatar
nfl wholesale nike jerseys cheap nike nfl jersey
avatar
jerseys cheap authntic cheap jersey fabric Ƅy the yard
avatar
hay day diamond 17/07/2017 15:55:06
If you plan on beginning a farm playing Hay Day, or presently play this free of charge online video game, making use of the Hay Day computer game cheats and also tips over plan to improve the resources available for play as well as the delightful.
1 2 next total: 15 | displaying: 1 - 10

Post your comment

  • Bold
  • Italic
  • Underline
  • Quote

Please enter the code you see in the image:

Captcha
  • Email to a friend Email to a friend
  • Print version Print version
  • Plain text Plain text

Tagged as:

No tags for this article

Rate this article

0