Home » Developer & Programmer » Forms » how to make loop ?
how to make loop ? [message #85921] Wed, 11 August 2004 23:47 Go to next message
Riena
Messages: 2
Registered: August 2004
Junior Member
hi...
i just want to ask,how to use looping if there got primary key on it...

for example in year 2004, one payment are made in feb 04 ,then on the same years, another payment are made in jun 04 ,so what command can be use here so the year did not change (overwrite)or the record can be save within the same years.please help me .....
wawawawaa....help me plz...

Report message to a moderator

Re: how to make loop ? [message #85925 is a reply to message #85921] Thu, 12 August 2004 04:50 Go to previous message
Nikhil Shukla
Messages: 2
Registered: August 2004
Junior Member
Hi,

U define date type for Year column. Store year data in date.

for i in(select distinct to_char(date_col,'YYYY')
from tab1)
loop

End Loop;

Report message to a moderator

Previous Topic: HELP ! BUTTON ICONS(.ico) not getting displayed on WEB but works fine in client-server mode
Next Topic: Running Oracle Forms 6i application in remote terminal
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Aug 07 12:33:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.