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
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
Messages: 38
Registered: May 2001
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?

Giridhar Kodakalla

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

Current Time: Fri Jun 25 04:43:10 CDT 2021