ORACLE I 3 – SQL 1. Salim Phone : 0815-188-2384 Email : [email protected] YM : talim_bansal. Summary. Retrieving Data Using the SQL SELECT Statement Restricting and Sorting Data Using Single-Row Functions to Customize Output. SELECT COMMON PATTERN.
SELECT <*, Field 1,….., Field n, Aggregate Function>
FROM < Table Name>
AND/OR <If any additional condition>
GROUP BY <Field 1,……, Field n>
ORDER BY <Field1,…., Field n>
List the comparison operators and logical operators that are used in a WHERE clause
Sample SELECT with WHERE using Comparison operators
Single Row Function VS Multiple Row Function
Single-row function: "functions return a single result row for every row of a queried table or view. "
Multiple row functions: "functions return a single result row based on groups of rows, rather than on single rows." an example using scott schema emp table:select empno, ename, to_char(sal, '9,999.99') from emp; --here to_char is a single row functionselect deptno, sum(sal) from emp group by deptno; --here sum() is a multiple row function.
Manipulate strings with character function
Character functions that return character values return values of the same datatype as the input argument. The length of the value returned by the function is limited by the maximum length of the datatype returned.
Manipulate strings with character function - Example
Number Function - Example