All articles from: February, 2007
Oracle Function:Translate & Replace
Posted on February 28, 2007 by Administrator
and has 6 comments.
Using Oracle function TRANSLATE and REPLACE to remove special characters from a string. This is the definition of the function. TRANSLATE(expr, from_string, to_string) Descrption: [FROM ORACLE DOCUMENTATION] TRANSLATE returns expr with all occurrences of each character in from_string replaced by its corresponding character in to_string. Characters in expr that are not in from_string are not [...]
Read moreOracle analytic functions
Posted on February 8, 2007 by Administrator
and has no comments yet.
I got an email from someone a couple of days ago. The email said ############## hi, i am having a problem here pls help me this is my i/p and o/p pls tell me logic to develop this input table or file 101,abc,5000 101,abc,2000 101,abc,1000 101,abc,1500 102,aaa,2000 102,aaa,1500 102,aaa,500 103,asa,1000 103,asa,300 103,asa,600 [...]
Read more