topic Views in Application Development and Automation Discussions

Views

Former Member — Fri, 18 Jan 2008 12:06:37 GMT

Hi all,

Will select statement can be imposed on a view? For example i have BSEG view. whether can i apply select statement on this view? if so can i apply join condition along with select statement??

Regards

Dhurga

Re: Views

Former Member — Fri, 18 Jan 2008 12:07:42 GMT

Hi,

Yes you can write a select statement on the databaase view.

Thanks,

Sriram POnna.

Re: Views

Former Member — Fri, 18 Jan 2008 12:15:31 GMT

Hi Sriram,

So can i use join condition also???

Thanks

Dhurga

Re: Views

Former Member — Fri, 18 Jan 2008 12:18:00 GMT

Hi,

No, you cannot use joins on views.

Thanks,

Sriram Ponna.