Replace function in Oracle sql.

 Trim :- Removes leading and /or trailing blanks(or other characters ) from a string.Syntax:- TRim([[<trim_spec >] char ]SQL> select trim(' Aptech Computer') from dual;Returns the following result.TRIM('APTECHCOM---------------Aptech ComputerConcate Function:--The syntax for the oracle concat function is :concat(string1,string2)Parameters...

Read More

Sub string functions in sql

 Substr: The oracle substr function allows you to extract a substring .The syntax for the oracle substr is as follows:-substr(string,start_position,[ length])SQL> select substr('santosh chaurasia',2,6) from dual;SUBSTR------antoshsql> select substr('priyaseth',4) from dual;SUBSTR------antoshSQL> select substr('avinashkare',-4) from dual;SQL>...

Read More