SQL Function Question

1. What is SQL function?
SQL function also we called as a Oracle Built in Function which is use for
Perform calculation on data
Modify individual data item
Manipulate output for group of rows.

2. How many type of SQL Function?
Single Row Functions :These functions return a single result for every row of a query table or view(this functions appear in SELECT,WHERE and ORDER BY).
Group Functions :These functions manipulate groups of rows and return one result per group of rows(this functions appear in SELECT and HAVING clauses).

3. What is SUBSTR function ?
SUBSTR is a oracle Built in Function which is return specific character , starting from specified position 'm' to 'n' characters long.

4. What is INSTR function ?
INSTR is a oracle Built in Function which is return the numeric position of a named charecter.

5. What is REPLACE function?

6. What is TRANSLATE function?

7. What is ROUNH function?

8. What is TRUNCATE function?

9. What is difference between ROUND and TRUNCATE?
Ans

10. What is difference between REPLACE and TRANSLATE?
Ans

11. What is the use of ADD_MONTHS function?

12. What is the use of MONTHS_BETWEEN function?

13. What is the use of NEXT_DAY function ?