Conventions used

There are a number of text conventions used throughout this book.

Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: “The ADD_MONTHS function has two parameters – date value (date_val) and the number of months (number_months) to be added or subtracted.”

A block of code is set as follows:

select ADD_MONTHS(TO_DATE('15.02.2022', 'DD.MM.YYYY'), 7)
  from dual;
--> 15.09.2022 00:00:00

Note, that statement results are prefixed by the --> notation.

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

select to_date('30.february 2022'
                 default null on conversion error,
               'DD.MM.YYYY')
 from dual;

Any command-line input or output, as well as syntax, is written as follows:

alter database set time_zone = '+09:00';

Bold: Indicates a new term, an important word, or words that you see onscreen. For instance, words in menus or dialog boxes appear in bold. Here is an example: “Database provisioning can be done by locating the menu on the home screen (Launch Resources) or by clicking on the hamburger menu and navigating to Oracle Database | Autonomous Database.”

Tips or important notes

Appear like this.