RosettaCodeData/Task/String-case/PL-SQL/string-case.sql

11 lines
239 B
MySQL
Raw Permalink Normal View History

2013-04-11 01:07:29 -07:00
declare
vc VARCHAR2(40) := 'alphaBETA';
ivc VARCHAR2(40);
lvc VARCHAR2(40);
uvc VARCHAR2(40);
begin
ivc := INITCAP(vc); -- 'Alphabeta'
lvc := LOWER(vc); -- 'alphabeta'
uvc := UPPER(vc); -- 'ALPHABETA'
end;