Software Engineering and Testing

344 SOF T WARE ENGINEERING AND TESTING

19.6 FUNCTIONS

1. Abs() — Returns the absolute value of an integer, i.e., converts a negative

value into a positive value.

Example: Select abs(field name) from tablename;

2. Avg() — Returns the average value and ignores null values.

Example: Select avg(field name) from tablename;

3. Count() — Returns the total number of rows in a table.

Example: Select count(*) from tablename;

4. Initcap() — Returns a string with the first letter in a capital letter.

Example: Select initcap(‘mahesh’) from dual;

The function returns a string ‘Mahesh.’

Dual is an Oracle work table where you can perform any operation. ...