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:
![]() | ![]() | ![]() |
No comments:
Post a Comment