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 … Read more

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 … Read more