Re: omit comments in PL/SQL source code

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!

>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.

Cheers,
Norm.

Remove the obvious bit to reply to my email address. Received on Tue Jun 08 2004 - 02:43:32 CDT