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
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: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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: 64119
Registered: March 2007
Location: Nanterre, France, http://...
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: ORA-06502:PL/SQL:numeric or value error: character string buffer too small in Oracle 10.2.0
Next Topic: validation
Goto Forum:
  


Current Time: Tue Dec 06 10:21:59 CST 2016

Total time taken to generate the page: 0.14781 seconds