Re: [sqr-users] CLOBs

["Jolene Osei" <SOSEI@kvcc.edu>]

Morning Melody

Thanks for the reply.  I want to extract the course descriptions in the
SCBDESC table.  I have to order the report by subject and course.
I have a problem of the description not wrapping around correctly. This
is the example that I am using as a test.

Select to_char(scbdesc_text_narrative) "Course Description"
    from  scbdesc
    where scbdesc_subj_code = 'ACC'
   and scbdesc_crse_numb = '100';


Course Description
--------------------------------------------------------------------------------
This is an introductory course to the Accounting cycle. The course is
designed t
o provide the student with a basic understanding of fundamental
bookkeeping conc
epts and procedures. Emphasis is placed on procedures, techniques, and
applicati
ons of generally accepted accounting principles.  This course will meet
the need
s of the small business owner or employee. It is required for
Accounting majors.

****************************************************

Hope to hear from you Melody.  I have run out of ideas. Thanks 

Jolene

 

>>> Melody.Sayles@alaska.edu 8/5/2005 12:47:49 PM >>>
What's your question? I've had two recent report projects that used
CLOB's.

Melody

Jolene Osei wrote:

> Hi
>
> Has anyone worked with the tables having CLOB fields.  I am creating
a
> report where by I have to extract from a CLOB field.  Has anyone
worked
> with this kind of a field?  I am working with Banner tables and this
> CLOB issue is new to us.
>
> Please help if you can
>
> Jolene
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 





_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users