Retrieving data using the SQL SELECT statement and using single row functions to customize the output
- /*…*/ and — are used to put comments in an Oracle program.
- The CREATE TABLE does not end immediately with a semicolon, and a column name cannot start with a numeric value. However, a numeric value can be used in between a column name.
- Name of a table cannot start with @ special character.
- Knowing about the GROUP BY clause.
Using sub queries and set operators to solve queries, as well as DDL statements to create and manage tables
- + (unary), – (unary), *, /, ||, =, !=, <, >, <=, >=, IS NULL, LIKE, BETWEEN, IN, NOT, AND, OR is the correct order of operators precedence.
Continue reading “OCP 1Z0-047 Short Notes: Exam passing tips”