Character Functions in PL/SQL

Character functions take VARCHAR2 or CHAR values as input and return either characters or numbers.
Character Functions

ASCII	INSTRC	NLS_LOWER	SUBSTR
ASCIISTR	LENGTH	NLS_UPPER	SUBSTR2
CHR	LENGTH2	NLSSORT	SUBSTR4
COMPOSE	LENGTH4	REGEXP_LIKE	SUBSTRB
CONCAT	LENGTHB	REGEXP_INSTR	SUBSTRC
DECOMPOSE	LENGTHC	REGEXP_REPLACE	TRANSLATE
INITCAP	LOWER	REGEXP_SUBSTR	TRIM
INSTR	LPAD	REPLACE	UNISTR
INSTR2	LTRIM	RPAD	UPPER
INSTR4	NCHR	RTRIM	INSTRB
NLS_INITCAP	SOUNDEX

No comments

There are still no comments on this article.

Leave your comment...

If you want to leave your comment on this article, simply fill out the next form:

You can use these XHTML tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> .

Identification

Article search

Sections

Oracle Administration (6.13.2010)
- Introduction to DataBase Administration (8.14.2010)
- Types of Oracle Database users (8.14.2010)
Oracle Backup and Recovery (6.13.2010)
- Oracle Backup:Basic concepts (8.15.2010)
- Oracle Recovery:Basic Concepts (8.15.2010)
Oracle PL/SQL (6.13.2010)
- ASCII Function in PL/SQL (6.19.2010)
- Oracle PL/SQL:Built In Exceptions (7.15.2010)
- PL/SQL:CASE Statement (7.15.2010)
- Character Functions in PL/SQL (6.19.2010)
- Comments in PL/SQL (6.18.2010)
- Conditional Control Statments (7.15.2010)
- Cursor FOR Loop (7.26.2010)
- Oracle PL/SQL:Data Types (7.15.2010)
- Oracle PL/SQL:Constants (7.15.2010)
- Oracle PL/SQL :Declaring Variables (7.15.2010)
- Delimiters (6.17.2010)
- EXIT Statement in PL/SQL (7.22.2010)
- EXIT-WHEN statement in PL SQL (7.22.2010)
- FOR Loop in Oracle PL SQL (7.26.2010)
- Fundementals of PL/SQL (6.15.2010)
  - Declarations (6.17.2010)
- PL/SQL:GOTO Statement (7.18.2010)
- Identifiers (6.16.2010)
- Identifiers(contd..) (6.16.2010)
- Oracle PL/SQL:IF-THEN-ELSE Statment (7.15.2010)
- INSTRC Function in PL/SQL (6.19.2010)
- Introduction to PL/SQL (6.13.2010)
- Lexical Units (6.15.2010)
- Loop statement In PL SQL (7.22.2010)
- Loops in Oracle PL SQL (7.20.2010)
- NLS_LOWER Function in PL/SQL (6.20.2010)
- Oracle Built In Functions:ACOS function (7.10.2010)
- Oracle Built In Functions:ADD_MONTHS Function (7.10.2010)
- Oracle Built In Functions:ATAN function (7.10.2010)
- Oracle Built in Functions:ATAN2 function (7.10.2010)
- Oracle Built in Functions:AVG function (7.10.2010)
- Oracle Built In Functions:CEIL function (7.10.2010)
- Oracle Built In Functions:EXP function (7.10.2010)
- Oracle Built In Functions:FLOOR function (7.10.2010)
- Oracle Built In Functions:LN function (7.10.2010)
- Oracle Built In Functions:MOD function (7.10.2010)
- Oracle Built In Functions:Numeric Functions (7.10.2010)
- Oracle Built In Functions:SIGN Function (7.10.2010)
- Oracle Built In Functions:SIN function (7.10.2010)
- Oracle Built In Functions:SINH function (7.10.2010)
- Oracle Built In Functions:SQRT function (7.10.2010)
- Oracle Built In Functions:TAN function (7.10.2010)
- Oracle Built in Functions:LOG function (7.10.2010)
- PL/SQL Built-in Functions (6.19.2010)
- PL/SQL Character Set (6.15.2010)
- RETURN Statement in PL SQL (7.22.2010)
- Sequential Control Statements (7.18.2010)
- Oracle PL/SQL:Stored Functions (7.15.2010)
- Oracle PL/SQL:Stored Procedures (7.15.2010)
- Oracle Pl/SQL Stored Procedures:Procedure Parameters (7.15.2010)
- Stored Procedures:Advanced Concepts (7.15.2010)
- WHILE Loop in Oracle PL SQL (7.27.2010)
Oracle Database Tuning (6.13.2010)
- SQL Tuning Tips-Identify Bad SQL Statements (8.12.2010)
Partners (8.4.2010)
Oracle SQL * Plus (6.13.2010)
- Introduction to SQL (7.12.2010)
- Introduction to SQL* Plus (8.2.2010)
- SQL Select Statement (8.8.2010)
- Script Files in SQL * Plus (8.3.2010)
- SQL * Plus Editing Commands (8.2.2010)
About Us (6.16.2010)

Last articles

Partitioning in oracle (3.26.2011)
Using SQL statements in C (2.15.2011)
UTL_FILE_DIR in Oracle (1.28.2011)
Use DECODE for IF/ELSE Selection (1.27.2011)
DBMS_ALERT Package (1.19.2011)
Oracle 11g:Automatic Storage Management (1.1.2011)
Using SQL Trace in oracle (12.29.2010)
Exception Handling in Oracle PL/SQL (12.21.2010)
Relational Database Management System(RDBMS) (12.21.2010)
Pseudocolumns in SQL (12.18.2010)

Monthly archives

Favourite sites

Subscribe to this site

Stay current with Techno Oracle on these personalized pages: