Re: fun debugging stuff on a friday

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 10 Apr 2009 09:50:27 -0500
Message-ID: <ad3aa4c90904100750l7b27502aubd52b39fffabbf1f_at_mail.gmail.com>

Are you getting an error? Did you turn on serveroutput? "set serveroutput on"

On Fri, Apr 10, 2009 at 9:47 AM, <TESTAJ3_at_nationwide.com> wrote:

>
> I get this code below, first glance says, this should work, Oracle is so
> much like C, gives you a gun, ammo, takes off the safety and has the trigger
> most of the way pulled while pointing the gun at your foot and assists you
> in pulling the trigger the rest of the way.
>
>
>
>
> declare
> current_date date;
> ctr number;
>
> begin
>
> current_date:='30-OCT-07';
>
>
> SELECT count(distinct SECURITY_ALIAS)
> into ctr
> FROM DATAMARTDBO.SECURITY_DETAILS
> WHERE EFFECTIVE_DATE = current_date;
>
> dbms_output.put_line('CTR1:'||ctr);
>
>
>
> SELECT count(distinct SECURITY_ALIAS)
> into ctr
> FROM DATAMARTDBO.SECURITY_DETAILS
> WHERE EFFECTIVE_DATE = '30-OCT-07';
>
> dbms_output.put_line('CTR2:'||ctr);
>
> end;
> /
>
> CTR1: 0
> CTR2: 35178
>
>
> _______________________________________
> Joe Testa, Oracle Certified Professional
> Senior Consultant
> Data Engineering and Administration
> Nationwide Investments
>
> (Work) 614-677-1668
> (Cell) 614-312-6715
>
> Interested in helping out your marriage?
> Ask me about "Weekend to Remember"
> Dec 11-13, 2009 here in Columbus.
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 10 2009 - 09:50:27 CDT