Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to implement the column heading in PL/SQL
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 - 08:58:58 CDT