|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
September 10th, 2004, 10:12 PM
|
|||
|
|||
|
Cursor Reference
Now I am writing some stored procedures in Oracle.
I am using cursor to add and edit records into the table. I want to know whether the cursor have the following function and it's syntax if have. (1) select * from table into cursor1. .......... cursor1.findfirst "field1='" & matching field & "'" if cursor1.nomatch then insert into table values ... else sqlstr:='update table set field1=''' || cursor1.field1 || '' where..... endif
__________________
Real, Nice and Beautiful are my hungry for knowledges.
|
|
#2
September 13th, 2004, 09:12 AM
|
|||
|
|||
|
Reply: cursor reference
Hi,
The cursor do not have such functions as described by you. Jigar
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Cursor Reference |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
