RE: Short_names vs long_names objects...
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 25 May 2004 12:34:48 -0400
There was a bug in 901/9201 when using forms. If you have views 9used in
oracle forms) whose name is 8,16 or 24 characters they didn't work. We
encountered this bug. It has been so long don't even remember what we
did to fix it, but anyways we quickly migrated to 9202.
As for the 30 chars limit, we had some developers who complained that 30
characters was too small to name an object, to which I once replied "you
really don't have to write a one liner, oracle doesn't execute the
object name". They got the joke and the meaning behind it.
Raj
------------------------------------------------------------------------
--------=20
Rajendra dot Jamadagni at nospamespn dot com=20
All Views expressed in this email are strictly personal.=20
select standard_disclaimer from company_requirements;=20
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Gorman
Sent: Tuesday, May 25, 2004 9:26 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Short_names vs long_names objects...
Ask them to prove it. Having "heard it somewhere" or "read about it
somewhere" is insufficient.
30 chars is the limit in the data dictionary columns for most names;
doing a describe on the data dictionary view or underlying table proves
this. As with all limits, there are many good reasons not to push up
close against them. Frequently other objects (i.e. indexes, triggers,
constraints, etc) benefit from having the table name as a component of
their name, so naming objects to accommodate these habits as well as the
30-char limit makes sense.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
