SELECT in CLOB column

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Tue, 30 Nov 2004 7:42 pm

Guys, how do I view the contents of a column of type CLOB with a SELECT?

Thanks ...
thiagomz
Location: Ribeirao Preto SP

Att.

Thiago M. Zerbinato
Oracle Certified Professional 8i

Poston Wed, 01 Dec 2004 7:56 am

Can use the DBMS_LOB Example:
Code: Select all
select dbms_lob.substr( campo_clob, 4000, 1 ) from tabela;
Links: how to insert a CLOB http://asktom.oracle.com/pls/ask/f?p=49 ... 8196216305, how to select a CLOB http://asktom.oracle.com/pls/ask/f?p=49 ... 7980988799,
tfg
Location: Novo Hamburgo - RS


  • See also
    Replies
    Views
    Last Post


            Return to PL/SQL

            Who is online

            Users browsing this forum: No registered users and 5 guests