The Language of SQL- P51

The Language of SQL- P51:Research has shown that, being pressed for time, most readers tend to skip the introduction of any book they happen to read and then proceed immediately to the first real chapter. With that fact firmly in mind, we will only cover relatively unimportant material in the introduction, such as an explanation of what you will and will not learn by reading this book. | 236 Index in Boolean logic 82-84 in columns 187-188 converting 42-43 converting in sorts 54 for COUNT function 100 in Oracle 52 overview of 10 relative to INSERT statement 177 representing 44 sorting 52-55 testing presence in WHERE clause 82-84 testing relative to LEFT JOIN 124 numeric datatypes kinds of 9 numeric functions PI 41 RAND 40-41 ROUND 40 See also scalar functions NumericValue argument using 40 O ON clause using with self join 133 ON keyword advantage of 115 using with INNER JOIN 112-113 open source database MySQL as 4 operators using in WHERE clause 65-66 using with WHEN keyword 66 Oracle case sensitivity of 86 CAST function 43 FROM clause in SELECT statements 31 34 column aliases 25 concatenation 24 CONCAT function 35 DD-MMM-YY date format 122 display of dash - for NULL values 44 double quote used with column names 18 137 DUAL dummy table 31 34 editions 4 AS keyword used with table aliases 116 limiting rows in 70 MINUS operator 160 NULLS FIRST keyword 52--53 NULL values 52 ROWNUM keyword 67 sorting rows in 70 stored procedures 165 SUBSTR function 32--34 37 table aliases 26 116 treatment of literal values 21 upper- and lowercase letters 53 UPPER function 86 use of double quote 18 Oracle Database installing 225 reference manuals 227 Oracle Database Express Edition installing 225--227 using 227 ORDER BY clause adding to SELECT statement 47-52 versus GROUP BY 105 order of processing 107 using 104 using with character data 54 using with TOP keyword 68 Orders alias assigning 26 Orders table calculated fields 20 CONCAT function 34-35 correlated subqueries 147-149 example 7 foreign keys 190 joining Customers table with 114-115 LEFT JOIN 123 AND operator 72-73 OR operator 73 outer joins 120 parentheses with Boolean logic 73--76 subqueries as data sources 143-145 UNION operator 154-156 using in join 111 values for outer joins 121 WHERE clause operators 65-66 OR operator combining with AND in WHERE clause 74--75 order of processing 74 using in Boolean logic 73 .