Types of SQL Functions
In Oracle Database SQL functions are divided into two categories. These two categories are –
Single Row Functions
Multiple row functions (Aggregate functions)
Types of Single-Row Functions
With Oracle, we have 5 types of Single-Row Functions
1. Character Functions
2. Number Functions
3. General Functions
4. Conversion Functions and
5. Date Functions.
Introduction to Oracle aggregate functions
Oracle aggregate functions calculate on a group of rows and return a single value for each group.
SQL function Interview question and answers
What is Oracle SQL function?
How many types of functions are there in SQL Server?
What is number function in SQL?
What is procedure and function in SQL?
What is built in function in Oracle?
What are SQL functions?
What is views in Oracle with example?
What are SQL triggers?
What is the function in PL SQL with examples?
What is procedure and function in Oracle?
What are multiple row functions in Oracle?
What is the difference between procedure and function in SQL?
0 comments:
Post a Comment