SQL Functions Overview

---

Database Table:

===========

         A database table is a table which contains the actual data.

Example: javanib,emp,login….etc

Non-Database Table:

===============

         A non-database table is a table which does not contain any information. 

Example: dual

These tables are used to

• Evaluate any Mathematical Expression
• Evaluate any Pseudo column values
• Evaluate any predefined functions

SQL Functions :
===============
             Function is a self content block which performs a specific task. SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements. Do not confuse SQL functions with user-defined functions written in PL/SQL.

1)System defined Functions:

   String/Char Functions: 

   Math/Numeric Functions: 

   Date Functions: 

 Multiple Row Functions: 

Miscellaneous Functions:

---