Home » SQL & PL/SQL » SQL & PL/SQL » Help in writing function.. regarding parameters of function
Help in writing function.. regarding parameters of function [message #268004] Mon, 17 September 2007 02:10 Go to next message
thisisnatesh
Messages: 92
Registered: March 2007
Karma: 0
Member
Hi All

i am stucked in writing in a function. please help me in the regard.

Problem is as follows..


I have a column in the table which contains all
the parameters to be passed to a function
which are seperated by ','.

Is like

param1
------
vempno,vename,vsal

Now i want to atomize the multiple values in the column,
and send them as parameters to another function.

please help me in this regard,
as i am confused from where i have to start.

Thanks in Advance

Nat
Re: Help in writing function.. regarding parameters of function [message #268017 is a reply to message #268004] Mon, 17 September 2007 02:56 Go to previous messageGo to next message
vamsi kasina
Messages: 2108
Registered: October 2003
Location: Hyderabad, India
Karma: 0
Senior Member
You can use substr and instr.

By
Vamsi
Re: Help in writing function.. regarding parameters of function [message #268020 is a reply to message #268004] Mon, 17 September 2007 03:02 Go to previous message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
If you search on "pivot" you'll likely find a solution or a link to a solution.

Regards
Michel
Previous Topic: Hard coding month and day to a year
Next Topic: mutating error problem
Goto Forum:
  


Current Time: Tue Aug 22 11:56:52 CDT 2017

Total time taken to generate the page: 0.13026 seconds