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
datatype conversion
object reference

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
Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Name Resolution   During the compilation, the PL/SQL compiler relates identifiers like the name of a variable with an address or memory location, actual value, or datatype. Th

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

Relational Operators The relational operators permit you to compare randomly complex expressions. The list below provides the meaning of each operator:

Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

The requirements as follows: Create a folder called "SECURITY" on the server and upload all your project files to that folder. Please note, the "SECURITY" folder is NOT to be IN

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de

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

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL