Noticed that on 10g there is functionality for CLOB to BLOB and BLOB to CLOB converson. Problem is that we are a few months away still from being on 10g. So whats a 9iR2 guy supposed to do... write your own.

Here are two handy functions you can use.. not sure what the max size conversions is but I would assume whatever LOB size max is.. so 4 GB for now ? and in 10g+ ... Terrabytes.

Pages: 1 · 2

Always forgetting about these useful functions... and even when we do, how to use them to our advantage....(see comments at bottom for example)

Ranking Function

Rank:-assigns A Unique Number For Each Row Starting With 1,except For Rows That Have Duplicate Values,in Which Case The Same Ranking Is Assigned And A Gap Appears In The Sequence For Each Duplicate Ranking.

Row_number:-returns A Unique Number For Each Row Starting With 1.for Rows That Have Duplicate Values,numbers Are Arbitarily Assigned.

Dense_rank:-assigns A Unique Number For Each Row Starting With 1,except For Rows That Have Duplicate Values ,in Which Case Same Ranking Is Assigned.

Pages: 1 · 2 · 3