Search Results

When you run the query standalone say in toad or sqlplus, does it give the desired result to you?

Guru.

Hi
Just below your 'set serverout on', add this line and try:

SET LINESIZE 100

Guru.