In SQL, you can use functions for everything from simple data manipulation to complex queries. For example, you can use a function to convert a date field to a numeric field, to substring a portion of a character field, to determine maximum salary by department, or to retrieve all orders for a particular customer. To use a function, you include the function name followed by parenthesis in an SQL statement and specify any required arguments for the function inside the parenthesis; empty ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.