Oracle Apps - How to retrieve data using view?

GeekInterview.com > Interview Questions > Oracle Apps

Go To First | Previous Question | Next Question

Oracle Apps | Question 32 of 61

How to retrieve data using view?

Total Answers and Comments: 4

Last Update: May 02, 2007 Asked by: arreddy

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 22, 2006 14:53:45

devesh288

RE: how to retrive data using view?

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.

Is this answer useful? Yes | No

October 09, 2006 17:54:31

Anil Reddy

RE: how to retrive data using view?

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.

Is this answer useful? Yes | No

January 23, 2007 23:21:33

ratnakar

RE: How to retrieve data using view?

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

Is this answer useful? Yes | No

May 02, 2007 06:12:05

shwetac

Member Since: May 2007 Contribution: 1

RE: How to retrieve data using view?

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;

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank