| How to simulate initcap function [message #20564] |
Wed, 05 June 2002 01:00  |
Kannan
Messages: 29
Registered: September 2000
|
Junior Member |
|
|
Sir,
How would you simulate the Oracle function initcap using SQL select statement only.
Usage of PL/SQL is discouraged.
Thanks
Kannan
|
|
|
|
| Re: How to simulate initcap function [message #20565 is a reply to message #20564] |
Wed, 05 June 2002 01:36  |
Sujit Mahapatra
Messages: 19
Registered: March 2002
|
Junior Member |
|
|
I think you can directly give the command using the
function initcap.
SELECT INITCAP ('hellO mY deAR friEND') FROM DUAL;
It is a simple SQL statement. I did not exactly
get the idea as why should you require the PL/SQL
construct?
Hope this works,
Cheers,
Sujit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
