

----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** Section5 ********************
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------


******************** TOPIC 1 ********************
export ORACLE_SID=PROD
.bash_profile OK



# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH
export ORACLE_SID=PROD
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export PATH=/u01/app/oracle/product/10.2.0/db_1/jdk/bin:$ORACLE_HOME/bin:$PATH
export LANG=en_US


******************** TOPIC 1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:31 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
OLTP_USER.SALES

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R101001=0.4


A: OLTP_USER.SALES

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:32 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
      9470

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A:       9470


R101001=0.6




******************** TOPIC 1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:32 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
STATUS
---------
ONLINE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R102001=0.5


A: ONLINE

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:32 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
STATUS
---------
AVAILABLE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R102002=0.5


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:33 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
STATUS
---------
ONLINE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R102002=1.0


B: ONLINE

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:33 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
OLTP_USER.SALES

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R102003=0.4


A: OLTP_USER.SALES

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:34 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> SQL> Connected.
SQL> 
  COUNT(*)
----------
      9470

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A:       9470


R102003=0.5




******************** TOPIC 2 ********************


******************** TOPIC 2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:34 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
8388608

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 8388608


R201000=0.1




******************** TOPIC 3 ********************


******************** TOPIC 3.1 ********************


******************** TOPIC 3.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 2

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 2


R301011=0.1



SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/lobdata01.dbf
/u01/app/oracle/oradata/PROD/Disk2/lobdata02.dbf

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 2


R301012=0.2




******************** TOPIC 3.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
  67108864
  67108864

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 2


R301020=0



SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
  67108864
  67108864

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 2


R301020=0.2



SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:35 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
  67108864
  67108864

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301020=0.2


A: 0


******************** TOPIC 3.1.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:36 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
BLOCK_SIZE
----------
     16384

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301030=0.2


A:      16384


******************** TOPIC 3.1.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:36 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
SEGMEN
------
AUTO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R301040=0.2


A: AUTO


******************** TOPIC 4 ********************


******************** TOPIC 4.1 ********************


******************** TOPIC 4.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:37 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
HR.MAGAZINE_ARTICLES
HR.ORACLE9I_REFERENCES
HR.ORIGINAL_SALARY
HR.MYTABLE
HR.REGIONS
HR.LOCATIONS
HR.DEPARTMENTS
HR.JOBS
HR.EMPLOYEES
HR.JOB_HISTORY
HR.COUNTRIES

11 rows selected.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401010=0.1


A: HR.MAGAZINE_ARTICLES


******************** TOPIC 4.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:37 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
USERS

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401020=0.1


A: USERS


******************** TOPIC 4.1.3 ********************


******************** TOPIC 4.1.3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 AUTHOR 																																																																										    VARCHAR2(30)
 ARTICLE_NAME																																																																										    VARCHAR2(50)
 ARTICLE_DATE																																																																										    DATE
 ARTICLE_DATA																																																																										    CLOB

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401031=0.1


A:  AUTHOR 																																																																										    VARCHAR2(30)


******************** TOPIC 4.1.3.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 AUTHOR 																																																																										    VARCHAR2(30)
 ARTICLE_NAME																																																																										    VARCHAR2(50)
 ARTICLE_DATE																																																																										    DATE
 ARTICLE_DATA																																																																										    CLOB

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401032=0.1


A:  ARTICLE_NAME																																																																										    VARCHAR2(50)


******************** TOPIC 4.1.3.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 AUTHOR 																																																																										    VARCHAR2(30)
 ARTICLE_NAME																																																																										    VARCHAR2(50)
 ARTICLE_DATE																																																																										    DATE
 ARTICLE_DATA																																																																										    CLOB

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401033=0.1


A:  ARTICLE_DATE																																																																										    DATE


******************** TOPIC 4.1.3.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:38 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 AUTHOR 																																																																										    VARCHAR2(30)
 ARTICLE_NAME																																																																										    VARCHAR2(50)
 ARTICLE_DATE																																																																										    DATE
 ARTICLE_DATA																																																																										    CLOB

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401034=0.1


A:  ARTICLE_DATA																																																																										    CLOB


******************** TOPIC 4.1.3.4.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:39 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
COLUMN_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ARTICLE_DATA

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401035=0.1


A: ARTICLE_DATA

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:39 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
LOB_DATA

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401036=0.5


A: LOB_DATA

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:40 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     CHUNK
----------
     16384

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401037=0.5


A:      16384

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:40 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>   2  
INITIAL_EXTENT
--------------
       2097152

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401038=0.2


A:        2097152

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:41 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>   2  
NEXT_EXTENT
-----------
    2097152

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R401039=0.2


A:     2097152


******************** TOPIC 4.1.3.4.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:42 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
CACHE
----------
NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R499999=0.3


A: NO

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:43 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
IN_
---
NO

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R499998=0.3


A: NO


******************** TOPIC 4.1.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
       302

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A:        302


R401040=0.4




******************** TOPIC 4.2 ********************


******************** TOPIC 4.2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
HR.MAGAZINE_ARTICLES
HR.ORACLE9I_REFERENCES
HR.ORIGINAL_SALARY
HR.MYTABLE
HR.REGIONS
HR.LOCATIONS
HR.DEPARTMENTS
HR.JOBS
HR.EMPLOYEES
HR.JOB_HISTORY
HR.COUNTRIES

11 rows selected.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402010=0.1


A: HR.ORACLE9I_REFERENCES


******************** TOPIC 4.2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:44 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
USERS

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402020=0.1


A: USERS


******************** TOPIC 4.2.3 ********************


******************** TOPIC 4.2.3.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ORACLE9I_ARTICLE																																																																									    ROWID
 INSERT_TIME																																																																										    TIMESTAMP(6) WITH LOCAL TIME ZONE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402031=0.1


A:  ORACLE9I_ARTICLE																																																																									    ROWID


******************** TOPIC 4.2.3.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ORACLE9I_ARTICLE																																																																									    ROWID
 INSERT_TIME																																																																										    TIMESTAMP(6) WITH LOCAL TIME ZONE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R402032=0.1


A:  INSERT_TIME																																																																										    TIMESTAMP(6) WITH LOCAL TIME ZONE


******************** TOPIC 4.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:45 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R403001=0


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
no rows selected

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R403002=0


A: 0


******************** TOPIC 5 ********************


******************** TOPIC 5.1 ********************


******************** TOPIC 5.1.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 5


R501010=0.03



SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 5


R501010=0.06



SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 5


R501010=0.09



SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 5


R501010=0.12



SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:46 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 5


R501010=0.15




******************** TOPIC 5.1.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:47 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> 
FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/data01.dbf
/u01/app/oracle/oradata/PROD/Disk2/data02.dbf
/u01/app/oracle/oradata/PROD/Disk3/data03.dbf
/u01/app/oracle/oradata/PROD/Disk4/data04.dbf
/u01/app/oracle/oradata/PROD/Disk5/data05.dbf

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 5


R501020=0.5




******************** TOPIC 5.1.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:48 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501031=0.03


A:  262144000

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:48 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501031=0.03


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:48 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501032=0.03


A:  262144000

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:48 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501032=0.03


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:49 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501033=0.03


A:  262144000

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:49 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501033=0.03


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:49 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501034=0.03


A:  262144000

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:49 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501034=0.03


A: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:50 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501035=0.03


A:  262144000

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:50 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
     BYTES
----------
 262144000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501035=0.03


A: 0


******************** TOPIC 5.1.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:50 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NEXT_EXTENT ALLOCATIO
----------- ---------
    4194304 UNIFORM

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501041=0.03


A:     4194304 UNIFORM

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:50 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NEXT_EXTENT ALLOCATIO
----------- ---------
    4194304 UNIFORM

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501042=0.03


A:     4194304 UNIFORM

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:51 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NEXT_EXTENT ALLOCATIO
----------- ---------
    4194304 UNIFORM

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501043=0.03


A:     4194304 UNIFORM

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:51 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NEXT_EXTENT ALLOCATIO
----------- ---------
    4194304 UNIFORM

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501044=0.03


A:     4194304 UNIFORM

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:51 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
NEXT_EXTENT ALLOCATIO
----------- ---------
    4194304 UNIFORM

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501045=0.03


A:     4194304 UNIFORM


******************** TOPIC 5.1.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:52 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
BLOCK_SIZE
----------
     16384

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501051=0.05


A:      16384

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:52 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
BLOCK_SIZE
----------
     16384

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501052=0.05


A:      16384

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:52 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
BLOCK_SIZE
----------
     16384

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501053=0.05


A:      16384

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:53 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
BLOCK_SIZE
----------
     16384

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501054=0.05


A:      16384

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:53 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
BLOCK_SIZE
----------
     16384

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R501055=0.05


A:      16384


******************** TOPIC 5.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:53 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
COLUMN_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SDATE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502000=0.5


A: SDATE

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PARTITI
-------
RANGE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502000=0.5


A: RANGE


******************** TOPIC 5.2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SALES_ID																																																																										    NUMBER
 NAME																																																																											    VARCHAR2(20)
 PROD_ID																																																																										    NUMBER
 SDATE																																																																											    DATE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502011=0.03


A:  SALES_ID																																																																										    NUMBER

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SALES_ID																																																																										    NUMBER
 NAME																																																																											    VARCHAR2(20)
 PROD_ID																																																																										    NUMBER
 SDATE																																																																											    DATE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502012=0.03


A:  NAME																																																																											    VARCHAR2(20)

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SALES_ID																																																																										    NUMBER
 NAME																																																																											    VARCHAR2(20)
 PROD_ID																																																																										    NUMBER
 SDATE																																																																											    DATE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502013=0.03


A:  PROD_ID																																																																										    NUMBER

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:54 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 SALES_ID																																																																										    NUMBER
 NAME																																																																											    VARCHAR2(20)
 PROD_ID																																																																										    NUMBER
 SDATE																																																																											    DATE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502014=0.03


A:  SDATE																																																																											    DATE


******************** TOPIC 5.2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:55 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>   2  
PARTITI PARTITION_COUNT
------- ---------------
RANGE		      5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502020=0.3


A: RANGE		      5

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:55 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>   2  
PARTITI PARTITIONING_KEY_COUNT
------- ----------------------
RANGE			     1

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502020=.6


B: RANGE			     1


******************** TOPIC 5.2.2.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:56 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PARTITION_NAME
------------------------------
P1
P2
P3
P4
P5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502021=0.1


A: P1

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:56 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
HIGH_VALUE
--------------------------------------------------------------------------------
TO_DATE(' 1999-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502021=.3


B: TO_DATE(' 1999-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:57 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
DATA01

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502021=.4


C: DATA01


******************** TOPIC 5.2.2.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:57 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PARTITION_NAME
------------------------------
P1
P2
P3
P4
P5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502022=0.1


A: P2

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:57 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
HIGH_VALUE
--------------------------------------------------------------------------------
TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502022=.3


B: TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
DATA02

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502022=.4


C: DATA02


******************** TOPIC 5.2.2.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:58 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PARTITION_NAME
------------------------------
P1
P2
P3
P4
P5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502023=0.1


A: P3

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:59 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
HIGH_VALUE
--------------------------------------------------------------------------------
TO_DATE(' 2001-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502023=.3


B: TO_DATE(' 2001-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:58:59 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
DATA03

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502023=.4


C: DATA03


******************** TOPIC 5.2.2.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:00 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PARTITION_NAME
------------------------------
P1
P2
P3
P4
P5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502024=0.1


A: P4

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:00 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
HIGH_VALUE
--------------------------------------------------------------------------------
TO_DATE(' 2002-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502024=.3


B: TO_DATE(' 2002-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
DATA04

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502024=.4


C: DATA04


******************** TOPIC 5.2.2.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PARTITION_NAME
------------------------------
P1
P2
P3
P4
P5

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502025=0.1


A: P5

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:01 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
HIGH_VALUE
--------------------------------------------------------------------------------
MAXVALUE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502025=.1


B: 0

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:02 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
DATA05

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R502025=.2


C: DATA05


******************** TOPIC 5.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:02 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
      4000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A:       4000


R503000=0.1




******************** TOPIC 5.4 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:03 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
INDEX_NAME
------------------------------
SALES_HISTORY_PK

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R504001=0.5


A: SALES_HISTORY_PK

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:03 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
PARTITION_COUNT
---------------
	      4

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R504002=0.3


A: 	      4

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:04 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
LOCALI
------
GLOBAL

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R504003=0.2


A: GLOBAL

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:04 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
UNIQUENES
---------
UNIQUE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R504004=0.1


A: UNIQUE


******************** TOPIC 5.4.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:04 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
COLUMN_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SALES_ID

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R504010=0.5


A: SALES_ID


******************** TOPIC 5.4.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:05 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
TABLESPACE_NAME
------------------------------
INDX
INDX
INDX
INDX

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R504020=0.5


A: 0


******************** TOPIC 5.4.3 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:05 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
DEGREE
----------------------------------------
4

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R504030=0.2


A: 4


******************** TOPIC 5.5 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:05 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
INDEX_NAME
------------------------------
SALES_HISTORY_DATE_IDX

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R505000=0.5


A: SALES_HISTORY_DATE_IDX


******************** TOPIC 5.5.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:06 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
COLUMN_NAME
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SDATE

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R505010=0.2


A: SDATE


******************** TOPIC 5.5.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:06 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
LOCALI
------
LOCAL

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R505020=0.5


A: LOCALI
LOCAL


******************** TOPIC 5.6 ********************


******************** TOPIC 5.7 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:07 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  SALES_ID NAME 		   PROD_ID SDATE
---------- -------------------- ---------- ---------
	 1 ICOL$			20 22-MAY-99

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R507000=0.4


A: 0


******************** TOPIC 6 ********************


******************** TOPIC 6.1 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:07 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
OBJECT_SCHEMA
------------------------------
HR

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R601000=0.2


A: HR

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:07 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
OBJECT_NAME
------------------------------
EMPLOYEES

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R601000=.4


B: EMPLOYEES

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:08 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
SEL
---
YES

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R601000=.6


C: YES

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:08 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
POLICY_TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SALARY IS NOT NULL AND COMMISSION_PCT IS NOT  NULL

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R601000=.8


D: SALARYISNOTNULLANDCOMMISSION_PCTISNOTNULL

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:08 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
POLICY_TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SALARY IS NOT NULL AND COMMISSION_PCT IS NOT  NULL

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R601000=1.0


E: SALARYISNOTNULLANDCOMMISSION_PCTISNOTNULL

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:09 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
POLICY_COLUMN
------------------------------
SALARY

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R601000=1.2


F: SALARY


******************** TOPIC 6.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:10 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------
       394	     HR 			    oracle																															    station23.example.com

 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------
oracle

 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------
HR			       EMPLOYEES															SALARYS 			   772567

 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------


 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------
select commission_pct from employees where salary is not null or commission_pct

 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------


 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------


 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------
											  1 12-JAN-15 03.59.10.356694 PM												     0 2201													   6	      1

 SESSIONID TIMESTAMP DBUID			    OSUID																															    OSHST															     CLIENTID
---------- --------- ------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------
EXTID
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
OBJ$SCHEMA		       OBJ$NAME 															POLICYNAME			      SCN
------------------------------ -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------
SQLTEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LSQLTEXT
--------------------------------------------------------------------------------
SQLBIND
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMMENT$TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PLHOL										  STMT_TYPE NTIMESTAMP# 								 PROXY$SID USER$GUID			     INSTANCE# PROCESS# 	XID		 AUDITID							   STATEMENT	ENTRYID       DBID LSQLBIND
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------


SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R602000=0.2


A: 0


******************** TOPIC 7 ********************


******************** TOPIC 7.1 ********************


******************** TOPIC 7.2 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:10 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select "EMPLOYEE_ID","COMMISSION_PCT","SALARY" from ORIGINAL_SALARY as of scn 762000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R702000=0.1


A: select "EMPLOYEE_ID","COMMISSION_PCT","SALARY" from ORIGINAL_SALARY as of scn 762000

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:10 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> SQL> SQL> 
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select "EMPLOYEE_ID","COMMISSION_PCT","SALARY" from ORIGINAL_SALARY as of scn 762000

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R702000=.3


B: select "EMPLOYEE_ID","COMMISSION_PCT","SALARY" from ORIGINAL_SALARY as of scn 762000

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:11 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 EMPLOYEE_ID																																																																										    NUMBER(6)
 COMMISSION_PCT 																																																																									    NUMBER(2,2)
 SALARY 																																																																										    NUMBER(8,2)

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R702001=0.1


A:  EMPLOYEE_ID																																																																										    NUMBER(6)

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:11 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 EMPLOYEE_ID																																																																										    NUMBER(6)
 COMMISSION_PCT 																																																																									    NUMBER(2,2)
 SALARY 																																																																										    NUMBER(8,2)

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R702002=0.1


A:  COMMISSION_PCT 																																																																									    NUMBER(2,2)

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:11 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 EMPLOYEE_ID																																																																										    NUMBER(6)
 COMMISSION_PCT 																																																																									    NUMBER(2,2)
 SALARY 																																																																										    NUMBER(8,2)

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R702003=0.1


A:  SALARY 																																																																										    NUMBER(8,2)

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:12 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
       107

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A:        107


R702004=0.5




******************** TOPIC 7.3 ********************


******************** TOPIC 7.3.1 ********************


******************** TOPIC 7.3.2 ********************


******************** TOPIC 7.4 ********************


******************** TOPIC 7.4.1 ********************


******************** TOPIC 7.4.2 ********************


******************** TOPIC 7.4.3 ********************


******************** TOPIC 7.4.4 ********************


******************** TOPIC 7.5 ********************


******************** TOPIC 7.5.1 ********************


******************** TOPIC 7.6 ********************

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:12 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
   MYVALUE
----------
	10

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R706000=0.13


A: SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:12 2015
	10
SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:12 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 MYNAME 																																																																										    DATE
 MYVALUE																																																																										    NUMBER(9)

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R706001=0.2


A:  MYNAME 																																																																										    DATE

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:12 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL>  Name																																																																										   Null?    Type
 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 MYNAME 																																																																										    DATE
 MYVALUE																																																																										    NUMBER(9)

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options


R706002=0.2


A:  MYVALUE																																																																										    NUMBER(9)

SQL*Plus: Release 10.2.0.2.0 - Production on Mon Jan 12 23:59:13 2015

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

SQL> Connected.
SQL> SQL> 
  COUNT(*)
----------
	 2

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options
VALUE_A: 	 2


R706003=0.35


****************************************************************************************************


R101001: 0.6 full is 0.6 0.6
R102001: 0.5 full is 0.5 1.1
R102002: 1.0 full is 1 2.1
R102003: 0.5 full is 0.5 2.6
R201000: 0.1 full is 0.1 2.7
R301011: 0.1 full is 0.1 2.8
R301012: 0.2 full is 0.2 3.0
R301020: 0.2 full is 0.2 3.2
R301030: 0.2 full is 0.2 3.4
R301040: 0.2 full is 0.2 3.6
R401010: 0.1 full is 0.1 3.7
R401020: 0.1 full is 0.1 3.8
R401031: 0.1 full is 0.1 3.9
R401032: 0.1 full is 0.1 4.0
R401033: 0.1 full is 0.1 4.1
R401034: 0.1 full is 0.1 4.2
R401035: 0.1 full is 0.1 4.3
R401036: 0.5 full is 0.5 4.8
R401037: 0.5 full is 0.5 5.3
R401038: 0.2 full is 0.2 5.5
R401039: 0.2 full is 0.2 5.7
R401040: 0.4 full is 0.4 6.1
R402010: 0.1 full is 0.1 6.2
R402020: 0.1 full is 0.1 6.3
R402031: 0.1 full is 0.1 6.4
R402032: 0.1 full is 0.1 6.5
R403001: 0 full is 0.3 6.8
R403002: 0 full is 0.3 7.1
R499998: 0.3 full is 0.3 7.4
R401038: 0.2 full is 0.2 5.5
R401039: 0.2 full is 0.2 5.7
R401040: 0.4 full is 0.4 6.1
R402010: 0.1 full is 0.1 6.2
R402020: 0.1 full is 0.1 6.3
R402031: 0.1 full is 0.1 6.4
R402032: 0.1 full is 0.1 6.5
R403001: 0 full is 0.3 6.8
R403002: 0 full is 0.3 7.1
R499998: 0.3 full is 0.3 7.4
R499999: 0.3 full is 0.3 7.7
R501010: 0.15 full is 0.15 7.85
R501020: 0.5 full is 0.5 8.35
R501031: 0.03 full is 0.03 8.38
R501032: 0.03 full is 0.03 8.41
R501033: 0.03 full is 0.03 8.44
R501034: 0.03 full is 0.03 8.47
R501035: 0.03 full is 0.03 8.50
R501041: 0.03 full is 0.03 8.53
R501042: 0.03 full is 0.03 8.56
R501043: 0.03 full is 0.03 8.59
R501044: 0.03 full is 0.03 8.62
R501045: 0.03 full is 0.03 8.65
R501051: 0.05 full is 0.05 8.7
R501052: 0.05 full is 0.05 8.75
R501053: 0.05 full is 0.05 8.8
R501054: 0.05 full is 0.05 8.85
R501055: 0.05 full is 0.05 8.9
R502000: 0.5 full is 0.5 9.4
R502011: 0.03 full is 0.03 9.43
R502012: 0.03 full is 0.03 9.46
R502013: 0.03 full is 0.03 9.49
R502014: 0.03 full is 0.03 9.52
R502020: .6 full is 0.6 10.12
R502021: .4 full is 0.4 10.52
R502022: .4 full is 0.4 10.92
R502023: .4 full is 0.4 11.32
R502024: .4 full is 0.4 11.72
R502025: .2 full is 0.4 12.12
R503000: 0.1 full is 0.1 12.22
R504001: 0.5 full is 0.5 12.72
R504002: 0.3 full is 0.3 13.02
R504003: 0.2 full is 0.2 13.22
R504004: 0.1 full is 0.1 13.32
R504010: 0.5 full is 0.5 13.82
R504020: 0.5 full is 0.5 14.32
R504030: 0.2 full is 0.2 14.52
R505000: 0.5 full is 0.5 15.02
R505010: 0.2 full is 0.2 15.22
R505020: 0.5 full is 0.5 15.72
R507000: 0.4 full is 0.4 16.12
R601000: 1.2 full is 1.2 17.32
R602000: 0.2 full is 0.2 17.52
R702000: .3 full is 0.3 17.82
R702001: 0.1 full is 0.1 17.92
R702002: 0.1 full is 0.1 18.02
R702003: 0.1 full is 0.1 18.12
R702003: 0.5 full is 0.5 18.62
R706000: 0.13 full is 0.13 18.75
R706001: 0.2 full is 0.2 18.95
R706002: 0.2 full is 0.2 19.15
R706003: 0.35 full is 0.35 19.5
full of this section:
RESULT:
18.70


****************************************************************************************************
