Hello Ron I do not know this package because we use another reporter (business Objects). If it is like our there are clear pro and con for using views:
Pro: you CONTROL the access to oracle. Con: YOU control the access to oracle. The pro means that you write the selects and can tune them and optimize the access to the DB. The con means that you do a lot of work for them and you will maintain the views each time there are changes. Instead of setting up the connections between tables in the application, you will set it up in views and the developer will simply do select on the view. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -----Original Message----- > From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] > Sent: Thu, February 21, 2002 6:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Anybody against using views? > > We have several applications that use views extensively. On the other > hand > there are several apps that use no views at all. We have a new developer > who wants to use views when writing reports in Crystal Reports. The > application administrator is leery of using views and ask the DBA group > what > we think. I can see several reasons to use views and a few reasons not to > use them. I was just wondering what the rest of the group thought. > > Ron Smith > DBA > Kerr-McGee Corp > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
