Home » SQL & PL/SQL » SQL & PL/SQL » string to recordtype conversion
string to recordtype conversion [message #36360] Tue, 20 November 2001 05:30 Go to next message
Thiyagarajan
Messages: 9
Registered: October 2000
Junior Member
hi is there any function to convert a given string to a record type .the string will be given as
%rowtype only.but it will be a string.is there any function to convert this into a recordtype datatype.thanks in advance.bye thiyagu.

----------------------------------------------------------------------
Re: string to recordtype conversion [message #36366 is a reply to message #36360] Wed, 21 November 2001 01:44 Go to previous message
Giridhar
Messages: 38
Registered: May 2001
Member
Hai thiyagarajan,
In DBMS_UTILITY builtin package,there are two subprograms named "COMMA_TO_TABLE" AND "TABLE_TO_COMMA". These subprograms take comma separated string and coverts the values to the TABLE.
Will it be sufficient for you?

HTH
Giridhar Kodakalla

----------------------------------------------------------------------
Previous Topic: Dynamic SQL in stored procedures
Next Topic: Dynamic Select with parameters
Goto Forum:
  


Current Time: Tue Nov 26 15:07:28 CST 2024