Home » RDBMS Server » Server Administration » string format
string format [message #373792] Wed, 09 May 2001 18:59
Raj
Messages: 411
Registered: November 1998
Senior Member
i am trying to write a function which takes in a string and a mask and then convert the string based on the mask provided.
fn('string','MASK or format')= formatted string
for example fn('GOAT','AbAAbA') result = G OA T
fn('G98T5H','A(9-9)A9-A') result = G(9-8)T5-H

where in the mask ..we use
A ---- any letter
9 ---- any number
b ---- BLANK space

can some one please help me with this..thanks in advance
Previous Topic: Obtaining the Text of SQL Statements in PL/SQL
Next Topic: privilege
Goto Forum:
  


Current Time: Tue Jul 02 17:45:57 CDT 2024