Re: How to query ...?

From: ganesh bora <lalitmohanpadey_at_gmail.com>
Date: 30 Jan 2007 02:18:25 -0800
Message-ID: <1170152305.582757.83990@h3g2000cwc.googlegroups.com>

hi if it helps ...??

create or replace procedure numbers is

   i number :=1;
   j number :=1;
   flag number :=5;
begin

    loop

            for j in 1..flag
                loop
                    dbms_output.put(i);
                     i:=i+1;
                     end loop;
                   if flag = 5 then
                    flag :=3;
                    else flag :=5;
                    end if;
                   dbms_output.put('*');
                   dbms_output.new_line;
      exit when (i=1000);

    end loop;
end ;

On Jan 30, 2:40 pm, Jeremy <jeremy0..._at_gmail.com> wrote:
> In article <1170138729.917043.271..._at_p10g2000cwp.googlegroups.com>,
> Fhatoy says...
>
> > Dear all,
>
> > How can I write the number from 1 to 1000 on the screen like the
> > following in Oracle ?
>
> > 12345*678*910111213*141516*1718192021*....
>
> > Please help me...What are the * supposed to represent?
> --
> jeremy
Received on Tue Jan 30 2007 - 04:18:25 CST