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

selecting from database view

Former Member

‎2007 Feb 09 4:10 AM

0 Likes
455

is it the same to get the values from view and table?

plz help me with example...

3 REPLIES 3
Read only

Former Member

‎2007 Feb 09 4:13 AM

0 Likes
433

it is just like SELECTing from a transparent table.

Select * into table zview from z_view.

Read only

Former Member

‎2007 Feb 09 4:14 AM

0 Likes
433

Hi,

Yes..But you can select only from projection view or database view..

Thanks

Naren

Read only

Former Member

‎2007 Feb 09 4:15 AM

0 Likes
433

Yes its the same:

SELECT * FROM <view / table> INTO TABLE ITAB WHERE <condition>.

Provided the ITAB is having view / table structure.

Thanks