|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Cursor Reference 2
In recordset, there is a feature as below:
Dim rs as recordset rs=currendb.openrecordset("table") rs.fields("fieldname").value=.... In cursor of oracle, what the syntax should be?
__________________
Real, Nice and Beautiful are my hungry for knowledges. |
|
#2
|
|||
|
|||
|
Reply: cursor reeference 2
In oracle
v1 number; Cursor c1 is select empno from emp; ---defination open c1; -- open cursor loop fetch c1 into v1; --fetch record set one by one exit when c1%notfound; ---this is neccesary condition otherwise database will hand as infinite loop will be there --do processing here------- close c1; --close cursor end loop; Jigar |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > Cursor Reference 2 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|