Home » SQL & PL/SQL » SQL & PL/SQL » How to make output from shah to s***
How to make output from shah to s*** [message #403779] Mon, 18 May 2009 10:46 Go to next message
carillpower
Messages: 48
Registered: April 2009
Location: malaysia
Member

Hi every guru's...i kinda need your help here...i got doubt on how to change value from existing like 'shah' to 's***' ....could anyone teach me how to did that...thanks an advance for teaching me Razz
Re: How to make output from shah to s*** [message #403781 is a reply to message #403779] Mon, 18 May 2009 10:58 Go to previous messageGo to next message
joicejohn
Messages: 327
Registered: March 2008
Location: India
Senior Member
@carillpower

Go through the following functions:

RPAD Function
SUBSTR Function
LENGTH Function

Hope these helps.

Regards,
Jo
Re: How to make output from shah to s*** [message #403782 is a reply to message #403779] Mon, 18 May 2009 11:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TRANSLATE
REGEXP_REPLACE

Regards
Michel
Re: How to make output from shah to s*** [message #403801 is a reply to message #403779] Mon, 18 May 2009 15:54 Go to previous message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Based on what rule?
Previous Topic: ORA-00932: inconsistent datatypes: expected - got CLOB
Next Topic: SMS using PL/SQL(merged)
Goto Forum:
  


Current Time: Thu Dec 08 14:44:45 CST 2016

Total time taken to generate the page: 0.08526 seconds