Tuesday 1 January 2013

Number Functions with example.

  1. Round - It is used to return the round figure.
  2. Trunc -
  3. ABS - It is used to return absolute value means positive integer.
  4. Mod - 
  5. Sqrt - It is used to show the square root of any number.
  6. Power - It is used to show the power of numbers.
  7. Floor - It is used to decrease the decimal value means remove all the decimal value.
  8. Ceil - It is used to get the upper value as exact.
  9. Round - It is used to return the round figure.
  10. Tan -
  11. Cos -
  12. Sin -

Important keywords in oracle

Orcl This is the host String in oracle.

Conn:- To Change the user in oracle.

Host:- To go on operating system.

/:- To run the previous Statement.

Tab:- It is used to select all the objects from user.