...
... $Header: README,v 6.6 91/05/04 17:23:39 nsalah Exp $ README Copyr (c) 1989 Oracle
...

 As part of pl/sql distribution, you will find 2 sets of demos; the first
 set (demo set A) contains 5 basic demos and one pro*c demo. The second
 set (demo set B) contains other miscellaneous examples and samples.



DEMO SET A:
==========

   LOADING PL/SQL DEMOS :
   ======================

    To load pl/sql demo tables and rows needed for demo set A, perform 
    the following :

    1) invoke sqldba and connect to your system user.
       That is,
        $ sqldba
        sqldba>connect system/<your system password>

    2) At the sqldba prompt, load the demos by invoking loaddemoa.sql .

        sqldba>@loaddemoa


   RUNNING THE PL/SQL DEMOS :
   =========================
 
        The demos are : demo1.sql , demo2.sql , demo3.sql , demo4.sql
                        demo5.sql and bankdemo.sql

        TO run the demos : 
                        invoke sqlplus to connect to the kernel using
                        the user plsqa/supersecret and type "@<test>"
                        or "start <test>" at the sqlplus prompt.
                        That is ,
                             $ sqlplus plsqa/supersecret
                             sqlplus>@demo1

        These demos are meant to be interactive and will guide you
        in a step-by-step fashion through the demonstration.
          
        When running the bank_demo.sql demo, you will be asked to build
        a bank_demo executable based on bank_demo.pc file. bank_demo.pc
        file contains embedded pl/sql blocks in a Pro*C program.
        To build the bank_demo executable, perform the following :

                    $ cd $ORACLE_HOME/c/demo
                    $ make -f proc.mk bank_demo     
                    $ bank_demo                        # to run.




DEMO SET B:
==========

   LOADING PL/SQL DEMOS :
   ======================

    To load pl/sql demo tables and rows needed for demo set B, perform 
    the following :

    1) invoke sqldba and connect to your system user.
       That is,
	$ sqldba
	sqldba>connect system/<your system password>

    2) At the sqldba prompt, load the demos by invoking loaddemob.sql .

        sqldba>@loaddemob 
   

   RUNNING THE PL/SQL DEMOS :
   =========================

    There are two groups of pl/sql demos for demo set B; one group 
    demonstrates running pl/sql blocks from the kernel and the other 
    group demonstrates running pl/sql blocks from the precompilers.

    *** PL/SQL demos from the kernel: 

	   The demos are : examp1.sql , examp2.sql , examp3.sql , examp4.sql ,
			   examp5.sql , examp8.sql , examp9.sql , examp10.sql,
			   examp11.sql, examp12.sql, examp13.sql, examp14.sql,
			   sample1.sql, sample2.sql, sample3.sql, sample4.sql.

           TO run the demos : invoke sqlplus to connect to the kernel using
                    	      the user plsqa/supersecret and type "@<test>"
			      or "start <test>" at the sqlplus prompt.
			      That is ,
			            $ sqlplus plsqa/supersecret
			            sqlplus>@examp1

    *** PL/SQL demos from the precompilers:

	    The demos are : examp6.pc , examp7.pc , sample5.pc.

	    TO run the demos :
		      $ cd $ORACLE_HOME/c/demo
		      $ make -f proc.mk examp6        # for examp6.pc
		      $ examp6                        # to run. 

		   
