| |
character functions in sql
Today's class
various types of functions
char number and date functions
there are two types of functions in SQL
Single Row
Multiple Row
Case manipulation
lower
Upper
initcap
Character manipulation
Concat
substr
length
instr
lpad
rpad
TRIm
REPLACE
select lower(first_name) as "lower1" ,first_name normal, upper(first_name) upper1 , initcap(first_name || ' ' || last_name) initcap1 from employees
select concat('hello', 'world') from dual
select substr('oracle', 2,5) from dual
select length('venugopal darur'), initcap('venu gopal darur'), ('venu'|| 'darur'), concat('venu','darur') from dual
select instr('Arun mavuram', 'm') from dual
Select instr(first_name, 'm') ,first_name from employees
Select lpad(10000, 10, '*'), lpad(10000, 10, '-'),rpad (10000, 10, '*') from dual
select instr('Arun mavuram', 'm'), trim('r' from ' ranadheer') from dual
Please send comments to vgdarur.javafive@blogger.com
|
