casefuncs.sql

来自「codding for pszone one can use it at pl」· SQL 代码 · 共 15 行

declare
a char(15);b char(15);c char(15);
begin
a:='computer';
b:='science';
c:='world';
dbms_output.put_line('first character as capital'||initcap(a));
dbms_output.put_line('concat a and c'||concat(a,c));
dbms_output.put_line('lowercase of c'||lower(c));
dbms_output.put_line('uppercase of a'||upper(a));
dbms_output.put_line('left pad a with *'||lpad(trim(a),15,'*'));
dbms_output.put_line('right pad a with *'||rpad(trim(a),15,'*'));
end;
/