OCA12c – 1Z0-061 – Additional Reading 03

[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 in SELECT statements
  • 5 Using Conversion Functions and Conditional Expressions
    • 5.1 Describe various types of conversion functions that are available in SQL
    • 5.2 Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    • 5.3 Apply conditional expressions in a SELECT statement

Reading Material

1Z0-061 Objectives List

Oracle Database 12c OCA Certification

OCA12c – 1Z0-061 – Additional Reading 02

[Additional] Reading material for 1z0-061 Oracle Database 12c SQL Fundamentals test.

Chapter 2: Introducing SQL introduces you to writing simple queries using SELECT statement. It also introduces you to filtering and sorting data.

  • 2 Retrieving Data Using the SQL SELECT Statement
    • 2.1 Explain the capabilities of SQL SELECT statements
    • 2.2 Execute a basic SELECT statement
  • 3 Restricting and Sorting Data
    • 3.1 Limit the rows that are retrieved by a query
    • 3.2 Sort the rows that are retrieved by a query
    • 3.2 Use ampersand substitution to restrict and sort output at runtime

Reading Material

1Z0-061 Objectives List

Oracle Database 12c OCA Certification