Wednesday, 10th March 2010.

Oracle PL\SQL Lower Function

Posted on Thursday, 6th August 2009 by captainmi2

The lower function in Oracle PL\SQ converts all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function.
The syntax for the lower function is:
lower( str )
str is the string to convert to lowercase.
see example below.

SQL> select lower(’AbCD56efGHI45′) col1 from dual;
COL1
————-
abcd56efghi45
SQL>

Tags:
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

Oracle PL\SQL Upper Function

Posted on Thursday, 6th August 2009 by captainmi2

The upper function in Oracle PL\SQL converts all letters in the specified string to uppercase. If there are characters in the string that are not letters, they are unaffected by this function.
The syntax for the upper function is:
upper(str)
str is the string to convert to uppercase.
see example below.

SQL> select upper(’abcd2efgh3′) col1 from dual;
COL1
———-
ABCD2EFGH3
SQL>

Tags:
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

Oracle PL\SQL Concat Function

Posted on Thursday, 14th May 2009 by captainmi2

Concat function in Oracle PL\SQL allows you to concatenate two strings together.
The syntax for the concat function is:
concat( string1, string2 )
string1 is the first string to concatenate.
string2 is the second string to concatenate.
Example:

SQL> select concat(’abcd’,'efgh’) as Col_1 from dual;
COL_1
——–
abcdefgh

Tags: ,
Posted in Basic, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

Oracle PL\SQL Trim Function

Posted on Thursday, 14th May 2009 by captainmi2

Trim function removes all specified characters either in the beginning or ending of the a string.
The syntax for the Trim function is:
trim( [ leading | trailing | both [ trim_character ] ] string1 )
leading – remove trim_string from the front of string1.
trailing – remove trim_string from the end of string1.
both – [...]

Tags:
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

Oracle PL\SQL Replace Function

Posted on Tuesday, 21st April 2009 by captainmi2

Replace Statement
The syntax for the replace function is:
replace( string1, string_to_replace, [ replacement_string ] )
string1 is the string to replace a sequence of characters with another set of characters.
string_to_replace is the string that will be searched for in string1.
replacement_string is optional. If replacement_string is omitted, it will just removed all occurrences of string_to_replace, and returns [...]

Tags:
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

About