SQL Reviewer

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: Oracle PL\SQL statement for Lower Function
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

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: Oracle PL\SQL statement for upper function
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

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: Add new tag, Oracle PL\SQL Concat Function
Posted in Basic, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

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: Oracle PL\SQL Trim Function
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)

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: Oracle PL\SQL Replace Function
Posted in Basic, Oracle, Oracle PL\SQL Functions, Oracle PL\SQL String Functions | Comments (0)