Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calculating average size of a CLOB column

Status
Not open for further replies.
mariocq

mariocq

MIS
Apr 20, 2001
61
US
Hello:

I have a table with two CLOBS colummns, I need to make the following:

a) Calculate the average size of the data stored in the CLOB columns
b) Find out the size of the biggest data stored in that columns.

Regards,
Mario.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
395
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC 2
Replies
5
Views
195
Livia8
Livia8
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
399
carp
carp
Andrzejek
  • Locked
  • Question
Modify columns - parts of virtual column 2
Replies
8
Views
821
carp
carp
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
335
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top