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