Home » RDBMS Server » Server Administration » HELP cursor
HELP cursor [message #369758] Thu, 05 October 2000 09:37 Go to next message
Martin Johansson
Messages: 11
Registered: October 2000
Junior Member
Hi..

Is it possible to do a select on a cursor.
Example:

nr_1 VARCHAR2(3);
CURSOR curs IS
SELECT anst,nr FROM mytable;

FOR i in curs LOOP
nr_1 := SELECT SUBSTR(i.nr,1,3) FROM curs <= ???
...
...
END LOOP;

Any help would be heplful

/Martin

Report message to a moderator

Re: HELP cursor [message #369759 is a reply to message #369758] Thu, 05 October 2000 09:39 Go to previous message
Highlander
Messages: 5
Registered: October 2000
Junior Member
nr_1 VARCHAR2(3);
CURSOR curs IS
SELECT anst,nr FROM mytable;

FOR i in curs LOOP
nr_1 := SUBSTR(i.nr,1,3)
...
...
END LOOP;

Report message to a moderator

Previous Topic: using package dbms_standard
Next Topic: What is B-Tree and Bitmap index?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 12:03:38 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.