Advanced Oracle PL/SQL Developer's Guide - Second Edition

Conventions

In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "The modified SELECT query is then executed in the HR schema of the database."

A block of code is set as follows:

/*Create the stored procedure to set the context attribute*/
CREATE OR REPLACE PROCEDURE p_app_context (p_val VARCHAR2)
IS
BEGIN

   /*Create a namespace DEMO_CONTEXT*/
   DBMS_SESSION.SET_CONTEXT(
    NAMESPACE => 'DEMO_CONTEXT',
    ATTRIBUTE => 'COUNTRY',
    VALUE     =>  P_VAL);
  END;
/

New terms and ...