ORACLE I 3 – SQL 1. Salim Phone : 0815-188-2384 Email : email@example.com 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.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
3 – SQL 1
Phone : 0815-188-2384
Email : firstname.lastname@example.org
YM : talim_bansal
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
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