Home » SQL & PL/SQL » SQL & PL/SQL » Rowid
Rowid [message #831] Thu, 07 March 2002 02:31 Go to next message
Sandro
Messages: 6
Registered: March 2002
Junior Member
how do I have to do for assigning the value of ROWID to a variable (type NUMBER) ?

that is:
..........
Actual_Position NUMBER;
........
........

SELECT ROWID INTO Actual_Position
FROM Trie
WHERE ROWID = Pointer;

in this way it occurs an error.
How to do?

Thanks

Report message to a moderator

Re: Rowid [message #832 is a reply to message #831] Thu, 07 March 2002 04:06 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
use

Actual_Position ROWID;

Report message to a moderator

Previous Topic: can table name be a variable??? urgent
Next Topic: Update Statement Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 11:54:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.