Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Very long "WHERE" list.

Re: Very long "WHERE" list.

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Sat, 10 Jul 2004 16:39:19 +0100
Message-ID: <bq20f05bc9nt01avv4aafg86o3nr5qls0t@4ax.com>


On Fri, 09 Jul 2004 23:43:05 -0700, Daniel Morgan <damorgan_at_x.washington.edu> wrote:

>The following is perfectly legal too:
>
>BEGIN
> dbms_output.put_line(NULL);
>END;
>/

 No, it's not. The NULL here doesn't have a type, and so it'll raise a compile-time exception as there's several overloads of put_line and not enough information to select one.

 dbms_output.put_line('') would at least be legal.

> But if you write it you should be fired.

 Why is attempting to put blank lines into debug output a cause for dismissal?

--
Andy Hassall <andy_at_andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk         / http://www.andyhsoftware.co.uk/space
Received on Sat Jul 10 2004 - 10:39:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US