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
Aggregate Assignment The %ROWTYPE declaration cannot include an initialization clause. Though, there are two ways to assign values to all fields in a record at once. At First, t

Main features of PL/SQL A good way to get familiar with PL/SQL is to look at a sample program. The below program processes an order for tennis rackets. At first, it declares a

Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

Keyword and Parameter Description: boolean_expression: This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statement

Expression: This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. If th

Use the NOCOPY Compiler Hint By default, the OUT and IN OUT parameters are passed by the value i.e. the value of an IN OUT actual parameter is copied into the corresponding fo

Fetching with a Cursor The FETCH statements retrieve the rows in the result set one at a time. After each and every fetch, the cursor advance to the next row in the result set

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Third Step at defining type SID in SQL CREATE DOMAIN SID AS VARCHAR(5) CHECK ( VALUE IS NOT NULL AND SUBSTRING(VALUE FROM 1 FOR 1) = 'S' AND CAST('+'||SUBSTRING(VALUE

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that