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
EXECUTE Privilege To call an invoker-rights routine straightforwardly, the users should have the EXECUTE privilege on that routine. By yielding the privilege, you permit a user

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Exceptions An exception is the runtime error or warning condition that can be predefined or user-defined. The Predefined exceptions are raised implicitly through runtime system

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

Using FORALL and BULK COLLECT Together You can unite the BULK COLLECT clause with the FORALL statement, in that case, the SQL engine bulk-binds column values incrementally. In

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

Write an anonymous block that contains a PL/SQL procedure. The procedure takes two input parameter: oldZip and newZip, and it updates the zipcodes table by replacing all oldZip wit

Literals A literal is an explicit numeric, string, character, or Boolean value not represented by an identifier. Numeric literal 147 and the Boolean literal FALSE are some of