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).

 

 

                                                     Table: Built-in Functions

 

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

Ask an Expert

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

Write your message here..

Related Questions

Mixed notation, Mixed Notation The fourth procedure call shows that yo... Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Design a script and integrate procedures, Initial thought process: Design... Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

Controlling autonomous transactions, Controlling Autonomous Transactions ... Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Solve the business problems using sql, Use the MASCOT tables CREDITRS, PORD... Use the MASCOT tables CREDITRS, PORDS and PAYMENTS to write SQL queries to solve the following business problems. These tables / data are available to you via the USQ Oracle server

Opening a cursor variable, Opening a Cursor Variable The OPEN-FOR stat... Opening a Cursor Variable The OPEN-FOR statement relates a cursor variable with the multi-row query, executes the query, and then identifies the result set. The syntax for ope

Controlling cursor variables, Controlling Cursor Variables You use 3 s... Controlling Cursor Variables You use 3 statements to control the cursor variable: OPEN-FOR, FETCH, & CLOSE. At First, you OPEN a cursor variable FOR a multi-row query. Then, y

Use the returning clause -improve performance of application, Use the RETUR... Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Example of coalesce operator - sql, Example of COALESCE operator Examp... Example of COALESCE operator Example: Give the total of marks for each exam (simplified solution) SELECT CourseId, COALESCE ((SELECT SUM (Mark) FROM EXAM_MARK AS EM

%notfound - implicit cursor attributes, %NOTFOUND The %NOTFOUND is the... %NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state

Triggers, At times, customers make mistakes in submitting their orders and ... At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr