Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

how to retrive data from database views or projection views

Former Member

‎2007 Feb 08 7:45 AM

0 Likes
623

how to retrive data from database views or projection views

how to retrive data from database views or projection views

Reply
4 REPLIES 4
Read only

Former Member

‎2007 Feb 08 7:47 AM

0 Likes
610

Hi chintam,

1. Very simple

2. Just like normal select statement.

3. Select * from VIEWNAME.

4. (Instead of the tablename, we just have to give the viewname)

regards,

amit m.

Read only

Former Member
In response to Former Member

‎2008 Dec 04 6:50 AM

0 Likes
610

Hi,

Are u sure bringing data from view using select statement.

Regards,

BBR.

Read only

Former Member

‎2007 Feb 08 7:53 AM

0 Likes
610

Hi Chintam,

Getting data from a view is same as getting it from a table.

Write a selectquery just as u write for a database table and mention the view name in it instead of the table.Selct into an internal table.

And then check the data u selected in the internal table.

Regards,

Priyanka.

Read only

Former Member

‎2008 Dec 04 6:42 AM

0 Likes
610

Hi.

Retrieving data from database view is very much similar to get the data from tables. So check the syntax of tables. Same will work for database view also.

Thanks