Upon creating a notebook, it opens automatically, presenting you with a single paragraph using the default %sql interpreter. You can change the interpreter by explicitly specifying one of %script, %python, %sql or %md

1. In Oracle Machine Learning home page, select the project in which your notebook is available.
2. Go to the Oracle Machine Learning navigator, and select Notebooks. Alternatively, you can click the Notebooks quick link in the home page.
   In the right pane, all notebooks that are available in the project are listed.
3. Click the notebook that you want to open and edit.
   The selected notebook opens in edit mode.
4. In the edit mode, you can use the Oracle Machine Learning notebooks toolbar options to run code in paragraphs, for configuration settings, and display options.

   Figure 3-1 Notebook toolbar

   
   You can perform the following tasks:
   • Write code to fetch data
   • Click to run one or all paragraphs in the notebook.
   • Click to hide all codes from all the paragraphs in the notebook. Click it again to display the codes.
   • Click to hide all outputs from all the paragraphs in the notebook. Click it again to view the outputs.
   • Click to remove all outputs from all the paragraphs in the notebook. To view the output, click the run icon again.
   • Click to delete all the paragraphs in the notebook.
   • Click to export the notebook.
   • Click to search any information in the codes present in the notebook.
   • Click to view the list of keyboard shortcuts.
   • Click to set the order for interpreter bindings for the notebook.
   • Click to select one of the three notebook display options.
     • Click default to view the codes, output, and metadata in all paragraphs in the notebook.
     • Click Simple to view only the code and output in all paragraphs in the notebook. In this view, the notebook toolbar and all edit options are hidden. You must hover your mouse to view the edit options.
     • Click Report to view only the output in all paragraphs in the notebook.
   • Click to access paragraph specific edit options such as clear output, remove paragraph, adjust width, font size, run all paragraphs above or below the selected paragraph and so on.
   • Add dynamic forms such as the Text Input form, Select form, Check box form for easy selection of inputs and easy filtering of data in your notebook. Oracle Machine Learning supports the following Apache Zeppelin dynamic forms:

     • Text Input form — Allows you to create a simple form for text input.

     • Select form — Allows you to create a form containing a range of values that the user can select.

     • Check Box form — Allows you to insert check boxes for multiple selection of inputs.

   Note:

   The Apache Zeppelin dynamic forms are supported only on SQL interpreter notebooks.
5. Once you have finished editing the notebook, click Back.
   This takes you back to the Notebook page.

• Run a Notebook with Python Interpreter
  To run Python commands in a notebook, you must first connect to the Python interpreter. To use OML4Py, you must import the oml module.
• Run a Notebook with SQL Interpreter
  A notebook can contain many paragraphs which is a notebook component where you can write SQL statements, run PL/SQL scripts, and run Python commands. You can run one or all the paragraphs in a notebook.
• Call the Markdown Interpreter and Generate Static html from Markdown Plain Text
  Use the Markdown interpreter and generate static html from Markdown plain text.
• Export a Notebook
  You can export a notebook in Zeppelin format ( .json ) file and in Jupyter format ( .ipynb ), and later import them in to the same or a different environment.
• Import a Notebook
  You can import notebooks across Pluggable Databases (PDBs) into your workspace. You can also import Jupyter notebooks into Oracle Machine Learning.
• Create Check Box Forms in Notebooks
  The Check Box Form supports multiple selection of inputs in a paragraph. The inputs are available as check box options in the notebook.
• Create Select Forms in Notebooks
  The Select Form allows you to select input values from a list of values, and dynamically retrieve the selected values as defined in the paragraph.
• Create Text Input Forms in Notebooks
  The Text Input form allows you to dynamically retrieve values as defined in the notebook.