Re: Long columns obsolete

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:3fd1b26f$0$13673$afc38c87_at_news.optusnet.com.au...
|
| "Robert" <cookie - remove - @tref.nl> wrote in message
| news:bqs78c$lh1$1_at_reader10.wxs.nl...
| > Hi there,
| >
| >
| > I have a third party application which uses a lot of LONG columns.
| > I heard Oracle has them for backwards compatibility and from 9i they are
| > obsolete.
| >
| > Is this true ? I can't seems to find a statement on this at the oracle
| site
| >
| > If you had the choice would you use LONG's ?
| >
|
|
| Absolutely not. They've actually been deprecated since the invention of
LOBs
| in 8.0.
|
| After an exhaustive search of about 25 seconds, I came across this:
|
|

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adfnstyp.htm#430644
|
| wherein the quote is found:
|
| "Oracle Corporation recommends using the LONG datatype only for backward
| compatibility with old applications. For new applications, you should use
| the CLOB and NCLOB datatypes for large amounts of character data. "
|
| Regards
| HJR
| --
| ------------------------------------
| Oracle insights at www.dizwell.com
| ------------------------------------
|
|

Good advise. I suppose eventually Oracle will follow it. ;-{)

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production

SQL> select owner, table_name, column_name   2 from all_tab_columns
  3 where table_name like 'ALL\_%' escape '\'   4 and DATA_TYPE = 'LONG'
  5 /

OWNER      TABLE_NAME                     COLUMN_NAME
---------- ------------------------------ ---------------------
SYS        ALL_ARGUMENTS                  DEFAULT_VALUE
SYS        ALL_CLUSTER_HASH_EXPRESSIONS   HASH_EXPRESSION
SYS        ALL_CONSTRAINTS                SEARCH_CONDITION
SYS        ALL_IND_EXPRESSIONS            COLUMN_EXPRESSION
SYS        ALL_IND_PARTITIONS             HIGH_VALUE
SYS        ALL_IND_SUBPARTITIONS          HIGH_VALUE
SYS        ALL_MVIEWS                     QUERY
SYS        ALL_MVIEW_AGGREGATES           MEASURE
SYS        ALL_MVIEW_ANALYSIS             QUERY
SYS        ALL_REGISTERED_MVIEWS          QUERY_TXT
SYS        ALL_REGISTERED_SNAPSHOTS       QUERY_TXT
SYS        ALL_SNAPSHOTS                  QUERY
SYS        ALL_SUBPARTITION_TEMPLATES     HIGH_BOUND
SYS        ALL_SUMMARIES                  QUERY
SYS        ALL_SUMMARY_AGGREGATES         MEASURE
SYS        ALL_TAB_COLS                   DATA_DEFAULT
SYS        ALL_TAB_COLUMNS                DATA_DEFAULT
SYS        ALL_TAB_PARTITIONS             HIGH_VALUE
SYS        ALL_TAB_SUBPARTITIONS          HIGH_VALUE
SYS        ALL_TRIGGERS                   TRIGGER_BODY
SYS        ALL_VIEWS                      TEXT
WMSYS      ALL_WM_TAB_TRIGGERS            TRIGGER_BODY

22 rows selected.

• mcs