I would like to use the Initcap for each of the word in a sentence. For ex, if the column stores a value like 'payment due date' - I wanted that to be printed like 'Payment Due Date'.
CREATE TABLE Initcaps
(Desc_txt VARCHAR2(150)
);
INSERT INTO INITCAPS VALUES
('Payment due date'
);
INSERT INTO INITCAPS VALUES
('Terms(no of payments)'
);
INSERT INTO INITCAPS VALUES
('Conditions apply. see agreement'
);