Home » SQL & PL/SQL » SQL & PL/SQL » Assigning records to varchar2
Assigning records to varchar2 [message #244076] Mon, 11 June 2007 09:45 Go to next message
pyanko
Messages: 1
Registered: June 2007
Junior Member
Is there a way to assign a record to a varchar2 variable? The record has all varchar2 fields.

Report message to a moderator

Re: Assigning records to varchar2 [message #244087 is a reply to message #244076] Mon, 11 June 2007 10:07 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
concatenate all of the fields in the record into a single value, then assign it to the variable. However, the real question is why on earth would you want to?

Report message to a moderator

Previous Topic: Capture DBMS_OUTPUT in Windows script
Next Topic: Cursors vs new feautures in oracle
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 03 21:43:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.