Re: omit comments in PL/SQL source code

"Norman Dunbar" <Norman_at_JUNKTHISBIT.Bountiful.Demon.co.uk> wrote in message news:6arac0lumt0s8h9bus15u8fa7dp2umcapr_at_4ax.com...
> On Mon, 7 Jun 2004 22:38:08 +0100, "Niall Litchfield"
> <niall.litchfield_at_dial.pipex.com> wrote:
>
> >"Norman Dunbar" <Norman_at_JUNKTHISBIT.Bountiful.Demon.co.uk> wrote in
message
> >news:pu59c01cv9hl9eqeflhpu2gq9c4akv3uno_at_4ax.com...
> >> On 7 Jun 2004 08:44:41 -0700, b_at_buko.sk (Ivan Bukovcan) wrote:
> >>
> >> >Hi,
> >> >
> >>
> >> Sounds like fun .....
> >
> >
> >Each to his own I suppose.
> >
>
> I once wrote a 'compiler' on my Sinclair QL, to take procedures
> written in Archive'd database procedural language and convert them to
> SuperBasic for another database system called DataDesign. It *was* fun
> (and a total headache !) but then, I am a bit of a saddo - ask my
> wife!

I once wrote utter rubbish to a terrible design that is still in use today. That story isn't quite so good is it? Good to see you back posting.

> >What you mean you don't write code like
> >
> >create or replace procedure insult(p_name in varchar2,p_insult in
varchar2)
> >as
> >cursor c is select /*+ ORDERED */ a.* from sys.obj$ a,sys.obj$ b;
> >begin
> >for i in c loop
> > dbms_output.put_line(p_name||' you are the son of a '||p_insult||',
> >please remember hint syntax');
> >end loop;
> >end;
> >/
>
> Nice code, I especially like the DBMS_OUTPUT.PUT_LINE bit :o)

:)

> >
> >or in other words I think you forgot hints.
>
> I did !
> And I got the in-line comment wrong as well '--' not '//'. The joys of
> mixing your languages I suppose.

C'est la vie.

Regarde

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com