4.3.1 Create a Notebook

A notebook is a web-based interface for data analysis, data discovery, data visualization and collaboration.

Whenever you create a notebook, it has an interpreter settings specification. The notebook contains an internal list of bindings that determines the order of the interpreter bindings. A notebook comprises paragraphs which is a notebook component where you can write SQL statements, run PL/SQL scripts, and run Python commands. A paragraph has an input section and an output section. In the input section, specify the interpreter to run along with the text. This information is sent to the interpreter to be executed. In the output section, the results of the interpreter are provided.
To create a notebook:
  1. In the Oracle Machine Learning home page, click Notebooks. The Notebooks page opens.
  2. In the Notebooks page, click Create.
    The Create Notebook window appears.
  3. In the Name field, provide a name for the notebook.
  4. In the Comments field, enter comments, if any.
  5. Click OK.
Your notebook is created and it opens in the notebook editor. You can now use it to run SQL statements, run PL/SQL scripts, and run Python commands. To do so, specify any one of the following directives in the input section of the paragraph:
  • %sql - To call the SQL interpreter and run SQL statements
  • %script - To call PL/SQL interpreter and run PL/SQL scripts
  • %md - To call the Markdown interpreter and generate static html from Markdown plain text
  • %python - To call the Python interpreter and run Python scripts
  • %r - To call the R interpreter and run R scripts.