OCP
文章平均质量分 59
njujijunya
这个作者很懒,什么都没留下…
展开
-
Oracle Database 12c: SQL Workshop I: 02 Retrieving Data Using the SQL SELECT Statement
Retrieving Data Using the SQL SELECT StatementBasic SELECT StatementSELECT {*|[DISTINCT] column|expression [alias],...}FROM table;NULL values in the SELECT statement Null is a value that ...翻译 2018-08-27 23:54:30 · 146 阅读 · 0 评论 -
Oracle Database 12c: SQL Workshop I: 03 Restricting and Sorting Data
Restricting and Sorting DataLimiting rows with:——The WHERE clauseSELECT *|{[DISTINCT] column|expression [alias],...}FROM table[WHERE logical expression(s)];——The comparison conditions using ...翻译 2018-08-27 23:55:36 · 200 阅读 · 0 评论 -
Oracle Database 12c: SQL Workshop I: 05 Using Conversion Functions and Conditional Expressions
Using Conversion Functions and Conditional ExpressionsConversion Functions In some cases, the Oracle server receives data of one data type where it expects data of a different data type. When th...翻译 2018-08-31 23:40:33 · 228 阅读 · 0 评论 -
Oracle Database 12c: SQL Workshop I: 06 Reporting Aggregated Data Using the Group Functions
Reporting Aggregated Data Using the Group FunctionsGroup functions Group functions operate on sets of rows to give one result per group The COUNT function has three formats: • COUNT...翻译 2018-09-01 15:58:20 · 170 阅读 · 0 评论 -
Oracle Database 12c: SQL Workshop I: 04 Using Single-Row Functions to Customize Output
Using Single-Row Functions to Customize Output Single-row functions are used to manipulate data items. They accept one or more arguments and return one value for each row that is returned by the q...翻译 2018-08-29 23:32:04 · 165 阅读 · 0 评论 -
Oracle Database 12c: SQL Workshop I: 07 Displaying Data from Multiple Tables Using Joins
Displaying Data from Multiple Tables Using JoinsJoining Tables Using SQL:1999 SyntaxSELECT table1.column, table2.column FROM table1[NATURAL JOIN table2] |[JOIN table2 USING (column_name)] | [...翻译 2018-09-03 23:19:22 · 188 阅读 · 0 评论