Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1OMwZj08058 for ; Mon, 24 Feb 2003 16:58:35 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1OMwXJ08048 for ; Mon, 24 Feb 2003 16:58:33 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA29922; Mon, 24 Feb 2003 11:42:41 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005570CA; Mon, 24 Feb 2003 10:34:00 -0800 Message-ID: Date: Mon, 24 Feb 2003 10:34:00 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Wayne Straughn" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Wayne Straughn" Subject: RE: Using fully qualified table_name.database_object in application code? Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2DC33.85074F7B" ------_=_NextPart_001_01C2DC33.85074F7B Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable One possible disadvantage is that your apps are then 'tied' to a = particular schema... if you wanted to run them against another schema, you would have to go back and modify = everything... =20 To get around this: You could create public synonyms pointing to a particular schema's = tables so if a reason ever arose to switch schema you'd only have to modify one set of code... your public = synonym script. =20 Wayne Straughn -----Original Message----- Sent: Monday, February 24, 2003 12:29 PM To: Multiple recipients of list ORACLE-L code? I would like to know if it is advocated to use fully qualified = table_name.database objects in application code. Example would be schema.table_name in a PL/SQL code. I would like to know the Pros/Cons if there are any? Thanks in advance. _____ =20 Do you Yahoo!? Yahoo! = Tax = Center - forms, calculators, tips, and more ------_=_NextPart_001_01C2DC33.85074F7B Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
One=20 possible disadvantage is that your apps are then 'tied' to a = particular schema...  if you wanted to run
them against = another=20 schema,  you would have to go back and modify=20 everything...
 
To get = around=20 this:
You could = create public=20 synonyms  pointing to a  particular = schema's tables=20 so if a reason ever arose to
switch = schema you'd only=20 have to  modify one set of code... your public synonym=20 script.
 
Wayne=20 Straughn

 -----Original = Message-----
From:=20 laura pena [mailto:lizzpenaorclgrp@yahoo.com]
Sent: Monday, = February=20 24, 2003 12:29 PM
To: Multiple recipients of list=20 ORACLE-L
Subject: Using fully qualified = table_name.database_object=20 in application code?

I would like to know if it is advocated to use fully qualified=20 table_name.database objects in application code.

Example would be schema.table_name in a PL/SQL code.

I would like to know the Pros/Cons if there are any?

Thanks in advance.


Do you Yahoo!?
Yahoo!=20 Tax Center - forms, calculators, tips, and = more
------_=_NextPart_001_01C2DC33.85074F7B-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wayne Straughn INET: Wayne.Straughn@blpc.com.bb Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (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).