RE: Using fully qualified table_name.database_object in

[Nelson, Allan]

Title: Message

Most application developers in my experience are in love with synonyms exactly so they won't have to fully qualify the table name.  Oracle uses them fairly extensively in APPs.  They do require some overhead for looking up the synonym and they can be a mess if nested deeply enough.  Controlling use of synonyms on the other hand is a lot like herding cats.

 

Allan

-----Original Message-----
From: laura pena [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 10:29 AM
To: Multiple recipients of list ORACLE-L
Subject: Using fully qualified table_name.database_object in application 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.

---

Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, and more

______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]