Built-in functions-comparison operators, PL-SQL Programming

Built-In Functions

The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below:

error reporting
number
character
datatype conversion
date
object reference
miscellaneous


The table shows the functions in each and every category.

You can use all the functions in the SQL statements except the error-reporting functions SQLCODE and SQLERRM. You can also use all the functions in the procedural statements except the miscellaneous functions like DECODE, DUMP, & VSIZE.

The SQL aggregate functions such as AVG, GROUPING, COUNT, STDDEV, MIN, MAX, SUM, and VARIANCE are not built into PL/SQL. However, you can use them in the SQL statements (but not in the procedural statements).

 

 

964_Built-In Functions-comparison operators.jpg

                                                     Table: Built-in Functions

 

Posted Date: 10/3/2012 5:37:01 AM | Location : United States







Related Discussions:- Built-in functions-comparison operators, Assignment Help, Ask Question on Built-in functions-comparison operators, Get Answer, Expert's Help, Built-in functions-comparison operators Discussions

Write discussion on Built-in functions-comparison operators
Your posts are moderated
Related Questions
PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur

Parameter and Keyword Description:   table_reference: This keyword identifies the table or view that should be accessible when you execute the UPDATE statement, and for wh

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b

Find the account numbers of all customers whose balance is more than 10,000 $

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.