Home » SQL & PL/SQL » SQL & PL/SQL » How to simulate initcap function
How to simulate initcap function [message #20564] Wed, 05 June 2002 01:00 Go to next message
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 Go to previous message
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
Previous Topic: Re: Find Numbers
Next Topic: who is champion in sql\plsql
Goto Forum:
  


Current Time: Mon Nov 12 16:08:16 CST 2018