topic selecting from database view in Application Development and Automation Discussions

selecting from database view

Former Member — Fri, 09 Feb 2007 04:10:14 GMT

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

plz help me with example...

Former Member — Fri, 09 Feb 2007 04:13:12 GMT

it is just like SELECTing from a transparent table.

Select * into table zview from z_view.

Former Member — Fri, 09 Feb 2007 04:14:24 GMT

Hi,

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

Thanks

Naren

Former Member — Fri, 09 Feb 2007 04:15:24 GMT

Yes its the same:

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

Provided the ITAB is having view / table structure.

Thanks