4 Results for:CLOB

  • Sort by: 

Sorting a clob column

18 Dec 2006

I'm trying to sort a column type asc as well as desc. I'm able to sort the clob column desc but not able to sort it asc. Can you please help me out? Read More

How to concatenate rows into a single CLOB in PL/SQL

By Dan Clamage 16 Apr 2009

PL/SQL expert Dan Clamage explains how to concatenate rows into a single CLOB in PL/SQL. Read More

Using a BLOB data type in a CMP Enity Bean

16 Aug 2004

I got an email from a customer who wanted to use BLOB data type in their CMP entity bean. In this blog, I will provide an example and will discuss how can you develop your CMP EJBs to use a BLOB database type. Read More

Executing SQL statements using prepared statements and statement pooling

27 Jul 2009

In this database tutorial, find out about executing SQL statements using prepared statements and statement pooling. Learn what a statement pool is and how to retrieve long data types efficiently. Read More