Re: CLOB to VARCHAR2 -- (ver 9i)

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 18 Sep 2006 16:41:07 -0700
Message-ID: <1158622865.303800@bubbleator.drizzle.com>

matt_at_mailinator.com wrote:
> Sybrand Bakker wrote:

>> http://asktom.oracle.com/pls/ask/f?p=4950:8:13266295515100393693::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:18909757644296

>
> im not sure what youre referring to in that link. can you be more
> specific?
>
>

>> Please *ALWAYS* post your version in ordet to get *accurate* answers
>> and not waste peoples time.

>
> i am confused -- does my "Subject:" line not say its version 9? it does
> for me.
>
>

>> Oracle 8i, BTW, is desupported for more than a year.

>
> but im not on 8. im using 9, according to the IT folks here. but a side
> note on the time frame -- big orgs can be *very* slow to upgrade
> database servers, for many valid reasons.
>
>
> matt

Run this anonymous block:

set serveroutput on

DECLARE
 ver VARCHAR2(100);
 compat VARCHAR2(100);
BEGIN
   dbms_utility.db_version(ver, compat);    dbms_output.put_line('Version: ' || ver ||' Compatible: ' || compat); END;
/

Things may not be as they seem.

-- 
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group

Received on Mon Sep 18 2006 - 18:41:07 CDT