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

Home -> Community -> Usenet -> c.d.o.misc -> Re: LONG datatypes - what's the trick?

Re: LONG datatypes - what's the trick?

From: Paul A. Horan <paulh_at_nospam.twoplus.com>
Date: Fri, 5 Mar 1999 09:34:53 -0500
Message-ID: <eljoyTxZ#GA.242@nih2naab.prod2.compuserve.com>


>>But you can't insert or update them at all

Ummm.... Then I guess I'm missing the point of them existing at all? It's not that I think Larry Ellison is a stupid man, but to spend good money to develop a datatype that can't be inserted or updated from standard SQL???

Paul Horan

Daniel Clamage wrote in message <7bnj1b$iae$1_at_remarQ.com>...
>You can use dbms_sql to get a long out of a column and into a set of
>varchar2 (such as a PL/SQL table of varchar2). You can also determine the
>length of the long with dbms_sql. But you can't insert or update them at
>all, except from C or COBOL.
>
>--
>- Dan Clamage
>http://www.telerama.com/~dclamage
>If you haven't crashed the Server,
>you haven't been trying hard enough.
>
>
>
Received on Fri Mar 05 1999 - 08:34:53 CST

Original text of this message

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