Sunday, October 14, 2012

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:

No comments:

Post a Comment

back to top