5.1 Create a Notebook Classic

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

Whenever you create a Notebook Classic, it has an interpreter settings specification. The Notebook Classic contains an internal list of bindings that determines the order of the interpreter bindings. A Notebook Classic 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 Classic:

1. On the Oracle Machine Learning UI home page, click Notebooks Classic. The Notebooks Classic page opens.
2. On the Notebooks Classic 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 Classic is created and it opens in the notebook editor. You can now use it to run SQL statements, run PL/SQL scripts, run Python, R and Conda commands. To do so, specify any one of the following directives in the input section of the paragraph:

• %sql — To connect to the SQL interpreter and run SQL statements
• %script — To connect to the PL/SQL interpreter and run PL/SQL scripts
• %md — To connect to the Markdown interpreter and generate static html from Markdown plain text
• %python — To connect to the Python interpreter and run Python scripts
• %r — To connect to the R interpreter and run R scripts.
• %conda — To connect to the Conda interpreter, and install third-party Python and R libraries inside a notebook session.