| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: clobs
Thank you so very much Gaja.
;-)
Thank you, thank you, thank you....!!!!
;-)
-jaime
> OK,
>
> I looks like the server stripped out my attachment. The
> following is the code dump.
>
> Thanks,
>
> Gaja.
>
> -----------------------------------------------------------------
> set echo off
> set pause off
> REM Demonstration of manipulating CLOBS
> REM Last modified by Gaja Vaidyanatha 15-NOV-97
> REM Made examples more meaningful
> REM Modified script to be compliant with 8.0.3 syntax, added
> REM documentation and made it more elegant
>
> set echo off
> PROMPT General Clean Up
> set echo on
> drop table emp;
>
> set echo off
> PAUSE Create EMP_TYP object type
> set echo on
> CREATE OR REPLACE TYPE emp_typ as object
> ( emp_no NUMBER (7),
> ename VARCHAR2 (20),
> resume CLOB );
> /
>
> set echo off
> PAUSE Create an object table of the emp_TYP type
> set echo on
> CREATE TABLE emp OF emp_typ;
>
> set echo off
> PAUSE Insert rows into emp table
> set echo on
> INSERT INTO emp
> VALUES (1, 'Jim Morrison', empty_clob());
> INSERT INTO emp
> VALUES (2, 'Credence Clearwater', empty_clob());
> COMMIT;
>
>
> set serveroutput on
> set echo off
> PAUSE Create an anonymous PL/SQL block
> set echo on
> DECLARE
> resume_ptr CLOB;
> resume_buffer VARCHAR2 (200);
> resume_offset NUMBER :=1;
> resume_amount BINARY_INTEGER := 41;
> lob_length number := 0;
> lob_contents VARCHAR2 (200);
> BEGIN
> SELECT e.resume INTO resume_ptr
> FROM emp e WHERE e.emp_no = 1
> FOR UPDATE;
>
> lob_length := DBMS_LOB.GETLENGTH(resume_ptr);
> dbms_output.put_line('Resume length before:
> '||to_char(lob_length));
> resume_buffer := '1968 - Formed the music group - The Doors';
>
> DBMS_LOB.WRITE (lob_loc => resume_ptr,
> amount => resume_amount,
> offset => resume_offset,
> buffer => resume_buffer);
> DBMS_LOB.READ(resume_ptr, resume_amount, resume_offset,
> lob_contents);
> DBMS_OUTPUT.PUT_LINE (lob_contents);
> lob_length := DBMS_LOB.GETLENGTH(resume_ptr);
> dbms_output.put_line('Resume length after:
> '||to_char(lob_length));
> COMMIT;
> END;
> /
>
> set echo off
> PROMPT *** End of Demo ***
>
> -----------------------------------------------------------------
>
> --- Jaime Perez <jaime_at_mail.laosb.org> wrote:
> > I didn't get the sample?
> >
> > -jaime
> >
> >
> > ----- Original Message -----
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > Sent: Thursday, June 01, 2000 1:32 PM
> >
> >
> > >
> > > <encoded content removed -- binaries not allowed by
> > ListGuru>
> > >
> > >
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, May 31, 2000 8:48 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Jaime,
> > >
> > > Attached is a short demo script of how to work with CLOBS.
> > This
> > > should provide you the foundation to build what you are
> > looking
> > > for. Hack away and do hope it helps.
> > >
> > > Cheers,
> > >
> > > Gaja.
> > >
> > >
> > > --- Jaime Perez <jaime_at_mail.laosb.org> wrote:
> > > > Well, I have to display that clob data in a web page using
> > > > either
> > > > Cold Fusion or ASP.
> > > >
> > > > If you have code that works on SQLPLUS, I would also like
> > > > to know how that is done.
> > > >
> > > > Thank you Andreas.
> > > >
> > > > -jaime
> > > >
> > > > Andreas Jung wrote:
> > > >
> > > > > On Tue, May 30, 2000 at 11:07:09AM -0800, Jaime Perez
> > wrote:
> > > > > > Morning everyone,
> > > > > >
> > > > > > Can someone show me or guide me on how I can
> > > > > > display full information from a clob field?
> > > > >
> > > > > With with application ? sqlplus ?
> > > > >
> > > > > Andreas
> > > > > --
> > > > > Author: Andreas Jung
> > > > > INET: ajung_at_sz-sb.de
> > > > >
> > > > > Fat City Network Services -- (858) 538-5051 FAX:
> > (858)
> > > > 538-5051
> > > > > San Diego, California -- Public Internet access /
> > > > Mailing Lists
> > > > >
> > > >
> > >
> >
> --------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an
> > E-Mail
> > > > message
> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru')
> > > > and in
> > > > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > > > (or the name of mailing list you want to be removed
> > from).
> > > > You may
> > > > > also send the HELP command for other information (like
> > > > subscribing).
> > > >
> > > > --
> > > > Author: Jaime Perez
> > > > INET: jaime_at_mail.laosb.org
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > > > 538-5051
> > > > San Diego, California -- Public Internet access /
> > > > Mailing Lists
> > > >
> > >
> >
> --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail
> > > > message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru')
> > > > and in
> > > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > > (or the name of mailing list you want to be removed from).
> >
> > > > You may
> > > > also send the HELP command for other information (like
> > > subscribing).
> > >
> > >
> > > =====
> > > Gaja Krishna Vaidyanatha | 3460 West Bayshore Road,
> > > Manager - Integration | Palo Alto, CA 94303
> > > & Consulting Services | gaja_at_brio.com
> > > Global Alliances | (650)-565-4442
> > > Brio Technology | www.brio.com
> > >
> > > "Opinions and views expressed are my own and not of Brio
> > Technology"
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Send instant messages & get email alerts with Yahoo!
> > Messenger.
> > > http://im.yahoo.com/
> > >
> > > --
> > > Author: Tony Guo
> > > INET: tonyg_at_actv.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > 538-5051
> > > San Diego, California -- Public Internet access /
> > Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from).
> > You may
> > > also send the HELP command for other information (like
> > subscribing).
> > >
> >
> > --
> > Author: Jaime Perez
> > INET: jaime_at_mail.laosb.org
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
> > You may
> > also send the HELP command for other information (like
> subscribing).
>
>
> =====
> Gaja Krishna Vaidyanatha | 3460 West Bayshore Road,
> Manager - Integration | Palo Alto, CA 94303
> & Consulting Services | gaja_at_brio.com
> Global Alliances | (650)-565-4442
> Brio Technology | www.brio.com
>
> "Opinions and views expressed are my own and not of Brio Technology"
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --
> Author: Gaja Krishna Vaidyanatha
> INET: gajav_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
Received on Fri Jun 02 2000 - 16:18:54 CDT
 |
 |