Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Datenformat LONG

Re: Datenformat LONG

From: Manuela Mueller <520040906697-0001_at_t-online.de>
Date: Wed, 09 Jan 2002 23:09:49 +0100
Message-ID: <3C3CBFAD.1C9CABBA@t-online.de>


Manuela Mueller wrote:
>
> Thomas Troendlin wrote:
> >
> > Hallo Gemeinde,
> >
> > Gibt es einen einfachen Weg (unter 20 Zeilen PL/SQL) Tabellen die eine
> > Spalte im LONG Format besitzen, entweder direkt oder über Umwege nach
> > VARCHAR2 konvertiert ?
> >
> > Ansonsten kann man ja wohl mit LONG wenig anfangen.
> >
> > Danke
> >
> > Thomas
>
> Hello Thomas,
> please post in english, do not multipost and include OS und Oracle
> Version.
> Regarding your question: It is unclear if you have an old application
> that forces you to use Datatype LONG, or if you try to code some new
> stuff.
> Oracle strongly recommends that you convert LONG into LOB.
> See
> http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/sql_elem.htm#45443
> for more infos about the datatypes. Create yourself a free account at
> OTN if you don't already have one.
> Please check "Ask Tom", there are many questions/answers with sample
> code about problems arising when working with LONG Datatype. Simply
> search for "LONG".
>
> Regards
> Manuela Mueller

Sorry, forgot the URL:
http://asktom.oracle.com/
Regards
Manuela Mueller Received on Wed Jan 09 2002 - 16:09:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US