devesh288

• Sep 22nd, 2006

 

you want to retrive the data by using view, so its depend that which type of data you want. find some query below:

1. select * from view_name;

2. select column_name from view_name;

3.  select column_name from view_name where column_name =/like '';

view is nothing just like as a table.

Anil Reddy

• Oct 9th, 2006

 

What devesh said is True for fetching but when it comes to its Definition and other storage its much different from Table.

View stores only its definition in Data Base, but where as Table store all its contents.

When a view is queried, the data is available and the data is not stored any where in Data Base.

ratnakar

• Jan 23rd, 2007

 

View is a virtual table we can create view by using following query Create view view_name as select * from table_namewe can select data from view by using following query.select * from view_name;we can update view if view is created based on single table.we can't update view if it is based on more than one table.Ratnakar Reddy

shwetac

 Profile Answers by shwetac 

• May 2nd, 2007

 

In Oracle Apps, to get data from views we have to set the org id for the application so that we can fetch relevant data. This can be done using the following block :

begin
fnd_client_info.set_org_context( <org_id> ) ;
end;