Difference between Ltrim, trim, substr, instr, rpad, lpad in oracle. #oracletutorial #sqlqueries

Difference between ltrim, rtrim, substr, instr, rpad, lpad in oracle.| Use of Ltrim in oracle | Use of rtrim in oracle | Use of substr in oracle | Use of instr in oracle | Use of rpad in oracle | Use of lpad in oracle

Difference between #ltrim, #rtrim, #substr, #instr, #rpad, #lpad in oracle.

select ename,substr(ename,2),ltrim(ename,'S'),rtrim(ename,'S'),instr(ename,'A'),rpad(ename,15,'-'),lpad(ename,15,':')from emp;

SUBSTR: WE CAN USE THE SUBSTR FUNCTION TO CLIPOUT A PIECE OF A STRING.
FORMAT:
SUBSTR(string,start[,count])

INSTR: IT FINDS THE LOCATION OF A CHARACTER IN A STRING.
FORMAT:
INSTR(string,set[,start[,occurance]])

RPAD AND LPAD ARE VERY SIMILIAR FUNCTIONS,RPAD ALLOWS YOU TO "PAD" THE RIGHT SIDE OF A COLUMN WITH ANY SET OF CHARACTERS.
THE CHARACTERS SET CAN BE ALMOST ANYTHING : SPACES,PERIODS,COLUMNS,LETTERS OR NUMBERS.....OR EVEN EXCLAMATION MARKS.
LPAD DOES THE SAME AS RPAD ......BUT FROM LEFT HAND SIDE.

FORMATS FOR RPAD AND LPAD.
RPAD(string,length[,'set'])
LPAD(string,length[,'set'])

LTRIM AND RTRIM ARE LIKE HEDGE TRIMMERS,THEY TRIM OFF UNWANTED CHARACTERS FROM LEFT AND RIGHT ENDS OF A STRING.

FORMAT:
RTRIM(string[,'set'])
LTRIM(string[,'set'])

NOW FOR THE EXAMPLE FOR BETTER UNDERSTANDING WE ARE GOING TO USE THE EMP TABLE....
LETS GET STARTED.

so we have seen here how all these functions work .

thanks for watching.

do like share and subscribe.