|
|
我的输出：
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------
******************** 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_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=PROD
export PATH=$ORACLE_HOME/jdk/binORACLE_HOME/binPATH
export LANG=en_US
******************** TOPIC 1.1 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:29 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 Sun Sep 13 19:09:29 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 Sun Sep 13 19:09:29 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 Sun Sep 13 19:09:29 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 Sun Sep 13 19:09:29 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 Sun Sep 13 19:09:29 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 Sun Sep 13 19:09:29 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 Sun Sep 13 19:09:30 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
VALUE
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
16777216
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: 16777216
R201000=0.1
******************** TOPIC 3 ********************
******************** TOPIC 3.1 ********************
******************** TOPIC 3.1.1 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:30 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 Sun Sep 13 19:09:30 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL> SQL>
FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/PROD/Disk1/lob_data01.dbf
/u01/app/oracle/oradata/PROD/Disk2/lob_data02.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 Sun Sep 13 19:09:30 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 Sun Sep 13 19:09:30 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 Sun Sep 13 19:09:30 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 Sun Sep 13 19:09:30 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
VALUE_A: 16384
R301030=0.2
******************** TOPIC 3.1.4 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:30 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 Sun Sep 13 19:09:30 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
HR.REGIONS
HR.LOCATIONS
HR.DEPARTMENTS
HR.JOBS
HR.EMPLOYEES
HR.JOB_HISTORY
HR.ORIGINAL_SALARY
HR.MYTABLE
HR.XXX
HR.MAGAZINE_ARTICLES
HR.COUNTRIES
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
HR.ORACLE9I_REFERENCES
12 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:31 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 Sun Sep 13 19:09:32 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL> 2
NEXT_EXTENT
-----------
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
A: 0
******************** TOPIC 4.1.3.4.2 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:32 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 Sun Sep 13 19:09:32 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 Sun Sep 13 19:09:32 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 Sun Sep 13 19:09:32 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
HR.REGIONS
HR.LOCATIONS
HR.DEPARTMENTS
HR.JOBS
HR.EMPLOYEES
HR.JOB_HISTORY
HR.ORIGINAL_SALARY
HR.MYTABLE
HR.XXX
HR.MAGAZINE_ARTICLES
HR.COUNTRIES
OWNER||'.'||TABLE_NAME
-------------------------------------------------------------
HR.ORACLE9I_REFERENCES
12 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 Sun Sep 13 19:09:32 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 Sun Sep 13 19:09:32 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 Sun Sep 13 19:09:32 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 Sun Sep 13 19:09:33 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
Table dropped.
SQL>
Table created.
SQL>
2 rows created.
SQL>
A B
------------------ ---------------------------------------------------------------------------
AAAC5nAAEAAAAwzABc 13-SEP-15 06.55.13.000000000 PM
AAAC5nAAEAAAAwzACA 13-SEP-15 06.55.13.000000000 PM
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.3
A: AAAC5nAAEAAAAwzABc 13-SEP-15 06.55.13.000000000 PM
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:33 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
Table dropped.
SQL>
Table created.
SQL>
2 rows created.
SQL>
A B
------------------ ---------------------------------------------------------------------------
AAAC5nAAEAAAAwzABc 13-SEP-15 06.55.13.000000000 PM
AAAC5nAAEAAAAwzACA 13-SEP-15 06.55.13.000000000 PM
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.3
A: AAAC5nAAEAAAAwzACA 13-SEP-15 06.55.13.000000000 PM
For R403001 and R403002 should detect again:
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:33 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
Table dropped.
SQL>
Table created.
SQL>
2 rows created.
SQL>
A B
------------------ ---------------------------------------------------------------------------
AAAC5nAAEAAAAwzABc 13-SEP-15 06.55.13.000000000 PM
AAAC5nAAEAAAAwzACA 13-SEP-15 06.55.13.000000000 PM
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.3
A: AAAC5nAAEAAAAwzABc 13-SEP-15 06.55.13.000000000 PM
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:33 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
Table dropped.
SQL>
Table created.
SQL>
2 rows created.
SQL>
A B
------------------ ---------------------------------------------------------------------------
AAAC5nAAEAAAAwzABc 13-SEP-15 06.55.13.000000000 PM
AAAC5nAAEAAAAwzACA 13-SEP-15 06.55.13.000000000 PM
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.3
A: AAAC5nAAEAAAAwzACA 13-SEP-15 06.55.13.000000000 PM
******************** TOPIC 5 ********************
******************** TOPIC 5.1 ********************
******************** TOPIC 5.1.1 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:33 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 Sun Sep 13 19:09:33 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 Sun Sep 13 19:09:33 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 Sun Sep 13 19:09:33 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 Sun Sep 13 19:09:33 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:34 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 Sun Sep 13 19:09:35 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 Sun Sep 13 19:09:35 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 Sun Sep 13 19:09:35 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 Sun Sep 13 19:09:35 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 Sun Sep 13 19:09:35 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 Sun Sep 13 19:09:35 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
VALUE_A: 16384
R501051=0.05
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:35 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
VALUE_A: 16384
R501052=0.05
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09: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
VALUE_A: 16384
R501053=0.05
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09: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
VALUE_A: 16384
R501054=0.05
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09: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
VALUE_A: 16384
R501055=0.05
******************** TOPIC 5.2 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:36 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 Sun Sep 13 19:09:36 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 Sun Sep 13 19:09:37 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 Sun Sep 13 19:09:37 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 Sun Sep 13 19:09:37 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 Sun Sep 13 19:09:37 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 Sun Sep 13 19:09:37 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 Sun Sep 13 19:09:37 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 Sun Sep 13 19:09:38 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 Sun Sep 13 19:09:38 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 Sun Sep 13 19:09:38 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 Sun Sep 13 19:09:38 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 Sun Sep 13 19:09:38 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 Sun Sep 13 19:09:38 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 Sun Sep 13 19:09:39 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 Sun Sep 13 19:09:39 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 Sun Sep 13 19:09:39 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 Sun Sep 13 19:09:39 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 Sun Sep 13 19:09:39 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 Sun Sep 13 19:09:39 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 Sun Sep 13 19:09:40 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 Sun Sep 13 19:09:40 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
HIGH_VALUE
--------------------------------------------------------------------------------
TO_DATE(' 2003-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
R502025=.3
B: TO_DATE(' 2003-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIA
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:40 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=.4
C: DATA05
******************** TOPIC 5.3 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:40 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 Sun Sep 13 19:09:40 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 Sun Sep 13 19:09:41 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 Sun Sep 13 19:09:41 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 Sun Sep 13 19:09:41 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 Sun Sep 13 19:09:41 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 Sun Sep 13 19:09:41 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 Sun Sep 13 19:09:42 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 Sun Sep 13 19:09:42 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 Sun Sep 13 19:09:42 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 Sun Sep 13 19:09:42 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: LOCAL
******************** TOPIC 5.6 ********************
******************** TOPIC 5.7 ********************
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:42 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 Sun Sep 13 19:09:42 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 Sun Sep 13 19:09:42 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 Sun Sep 13 19:09:42 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 Sun Sep 13 19:09:43 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
POLICY_TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SALARY is not null or 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: SALARYisnotnullorCOMMISSION_PCTisnotnull
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:43 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL>
POLICY_TEXT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SALARY is not null or 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: SALARYisnotnullorCOMMISSION_PCTisnotnull
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:43 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 Sun Sep 13 19:09:43 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
-------------------------------------------------------------------------------- ---------- --------------------------------------------------------------------------- ---------- -------------------------------- ---------- ---------------- ---------------- ---------------------------------------------------------------- ---------- ---------- ---------- --------------------------------------------------------------------------------
299 HR oracle station37.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 POLICY1 648465
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 13-SEP-15 11.09.43.729554 AM 0 15455 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 Sun Sep 13 19:09:43 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL> SQL> SQL>
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select "EMPLOYEE_ID","COMMISSION_PCT","SALARY","HIRE_DATE" from ORIGINAL_SALARY
as of timestamp
to_timestamp('2015-09-13:18:26:56','YYYY-MM-DD:HH24:MI:SS')
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","HIRE_DATE" from ORIGINAL_SALARY
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:43 2015
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
SQL> Connected.
SQL> SQL> SQL> SQL>
TEXT
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
select "EMPLOYEE_ID","COMMISSION_PCT","SALARY","HIRE_DATE" from ORIGINAL_SALARY
as of timestamp
to_timestamp('2015-09-13:18:26:56','YYYY-MM-DD:HH24:MI:SS')
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: TEXT------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------select"EMPLOYEE_ID","COMMISSION_PCT","SALARY","HIRE_DATE"fromORIGINAL_SALARYasoftimestampto_timestamp('2015-09-13:18:26:56','YYYY-MM-DD:HH24:MI:SS')SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>SQL>DisconnectedfromOracleDatabase10gEnterpriseEditionRelease10.2.0.2.0-ProductionWiththePartitioning,OLAPandDataMiningoptions
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:44 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)
HIRE_DATE NOT NULL 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
R702001=0.1
A: EMPLOYEE_ID NUMBER(6)
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:44 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)
HIRE_DATE NOT NULL 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
R702002=0.1
A: COMMISSION_PCT NUMBER(2,2)
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:44 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)
HIRE_DATE NOT NULL 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
R702003=0.1
A: SALARY NUMBER(8,2)
SQL*Plus: Release 10.2.0.2.0 - Production on Sun Sep 13 19:09:44 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 Sun Sep 13 19:09:44 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 Sun Sep 13 19:09:44 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 Sun Sep 13 19:09:44 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 Sun Sep 13 19:09:44 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 Sun Sep 13 19:09:44 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 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.3 full is 0.3 6.8
R403002: 0.3 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: .4 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:
19.30
****************************************************************************************************
|
|
发表于 2015-10-10 10:33:15
