Re: How to implement the column heading in PL/SQL
From: udaj <udaj_at_email.msn.com>
Date: Sat, 23 Oct 1999 09:58:58 -0400
Message-ID: <O7s9m6VH$GA.161_at_cpmsnbbsa02>
Date: Sat, 23 Oct 1999 09:58:58 -0400
Message-ID: <O7s9m6VH$GA.161_at_cpmsnbbsa02>
You can give a separate dbms_output.put_line statement outside you loop that will contain just the headings for each column you are going to output.
John <s2247504_at_cse.unsw.edu.au> wrote in message
news:M_gQ3.1858$we.3133_at_newsfeeds.bigpond.com...
> I know "heading" will do the work in SQL, but not sure what command I
should
> use in PL/SQL, combined with dbms_output.put_line (and cursor loop).
Should
> I use dbms_sql.define_column or anything else? Any help highly
appreciated.
>
>
Received on Sat Oct 23 1999 - 15:58:58 CEST