|
What is a union, intersect, minus? - Union operator is used to return all rows from multiple tables and eliminate duplicate rows...
|
|
Characteristics of function object - A function can allow one or more or no parameter...
|
|
Oracle translate and decode - Translate: translate function replaces a sequence of characters in a string with another set of characters. The replacement is done single character at a time...
|
|
Use of Translate Function in Oracle - The translate function performs a character wise replacement of a string...
|
|
What are Group Functions in Oracle? - This function returns the number of rows in the group. A column name or ‘*’ may be passed as a parameter...
|
|
WHERE clause vs HAVING clause - HAVING clause is used with group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns...
|
|
Function VS Procedure - A FUNCTION always returns a value using the return statement while a PROCEDURE may return one or more values through parameters or may not return at all...
|
|
Oracle numeric functions - NVL, ABS,CEIL,FLOOR, MOD, SQRT, EXP,LN AND LOG, ROUND AND TRUNC, AVG, COUNT, MAX, MIN AND SUM...
|
