Mastering the Oracle Stack, One Post at a Time.
Professional development. Certifications, conference notes, publications
[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 4: Using Group Functions explains data aggregations, Oracle’s built-in group function, and nesting of functions. 6 Reporting Aggregated Data Using the Group Functions 6.1 Identify the available group functions 6.2 Describe the use of group functions 6.3 Group data by using the GROUP BY … Read more
[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test. Chapter 3: Using Single-Row Functions discusses the single-row functions and conversion functions available, with details on how and where to use them. 4 Using Single-Row Functions to Customize Output 4.1 Describe various types of functions available in SQL 4.2 Use character, number, and date functions … Read more