Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
1.Introduction
1.1.dual ( 2 ) 1.6.Print ( 1 )
1.2.Arithmetic operator ( 2 ) 1.7.Variable ( 1 )
1.3.Comparison Operators ( 8 ) 1.8.Comments ( 3 )
1.4.Logical Operators ( 5 ) 1.9.Terminology ( 1 )
1.5.Null Values ( 2 ) 1.10.Database Normalization ( 1 )
2.Query Select
2.1.Introduction ( 3 ) 2.22.IS NOT INFINITE ( 1 )
2.2.Select clause ( 16 ) 2.23.IS NOT NAN ( 1 )
2.3.Where ( 10 ) 2.24.IS NULL ( 5 )
2.4.Order By ( 17 ) 2.25.NOT ( 11 )
2.5.Group By ( 20 ) 2.26.NOT BETWEEN ( 1 )
2.6.HAVING ( 8 ) 2.27.NOT IN ( 6 )
2.7.DISTINCT ( 3 ) 2.28.NOT LIKE ( 1 )
2.8.Columns ( 12 ) 2.29.Level ( 2 )
2.9.Concatenation ( 1 ) 2.30.ROWID ( 2 )
2.10.Arithmetic ( 3 ) 2.31.rownum ( 4 )
2.11.AND OR ( 13 ) 2.32.GUID ( 1 )
2.12.Alias ( 10 ) 2.33.ROW ( 3 )
2.13.ALL ( 3 ) 2.34.START WITH ( 2 )
2.14.ANY ( 3 ) 2.35.with ( 2 )
2.15.CASE ( 15 ) 2.36.Single Row Subquery ( 20 )
2.16.BETWEEN ( 4 ) 2.37.Correlated Subquery ( 11 )
2.17.IN ( 12 ) 2.38.Multiple Row Subquery ( 11 )
2.18.EXISTS ( 6 ) 2.39.Nested Subquery ( 4 )
2.19.LIKE ( 12 ) 2.40.Hierarchical Queries ( 12 )
2.20.IS INFINITE ( 1 ) 2.41.Multi column subquery ( 3 )
2.21.IS NAN ( 1 ) 2.42.CONNECT ( 3 )
3.Set
3.1.Introduction ( 3 ) 3.5.Union ( 8 )
3.2.Intersect ( 4 ) 3.6.MULTISET UNION ( 3 )
3.3.MINUS ( 3 ) 3.7.SUBMULTISET ( 1 )
3.4.Union All ( 3 )
4.Insert Update Delete
4.1.Insert ( 14 ) 4.5.Quotation Mark ( 3 )
4.2.Column Copy ( 1 ) 4.6.RETURNING ( 1 )
4.3.Update ( 19 ) 4.7.Insert Select ( 3 )
4.4.Delete ( 9 )
5.Sequences
5.1.Create Sequence ( 12 ) 5.5.Primary Key ( 1 )
5.2.Sequence Information ( 2 ) 5.6.Value ( 10 )
5.3.Modify Sequence ( 1 ) 5.7.Alter Sequence ( 1 )
5.4.Drop Sequence ( 1 )
6.Table
6.1.Create Table ( 16 ) 6.13.Check ( 18 )
6.2.View Table Structure ( 1 ) 6.14.Default Column Value ( 8 )
6.3.Alter Table ( 20 ) 6.15.Primary Key ( 8 )
6.4.Copy Table ( 7 ) 6.16.FOREIGN KEY ( 10 )
6.5.Merge ( 7 ) 6.17.References ( 2 )
6.6.Rename Table ( 1 ) 6.18.Table Storage ( 1 )
6.7.Comment ( 3 ) 6.19.tablespace ( 2 )
6.8.Drop Table ( 4 ) 6.20.Temporary Table ( 5 )
6.9.Truncate Table ( 1 ) 6.21.Add Column ( 4 )
6.10.Constraint ( 13 ) 6.22.Drop Column ( 1 )
6.11.NOT NULL ( 6 ) 6.23.comment ( 4 )
6.12.Unique ( 7 ) 6.24.Cluster ( 7 )
7.Table Joins
7.1.Introduction ( 8 ) 7.9.SQL 92 Syntax ( 3 )
7.2.Table Alias ( 8 ) 7.10.Outer Join SQL 92 Syntax ( 4 )
7.3.Inner Joins ( 4 ) 7.11.Self Join SQL 92 Syntax ( 1 )
7.4.Outer Joins Left Right ( 16 ) 7.12.Cross Join SQL 92 Syntax ( 1 )
7.5.Outer Joins Limitations ( 3 ) 7.13.natural join ( 1 )
7.6.Self Joins ( 3 ) 7.14.USING ( 4 )
7.7.Cartesian Products ( 1 ) 7.15.Order ( 1 )
7.8.Non equality table join ( 3 ) 7.16.Group ( 2 )
8.View
8.1.Create View ( 16 ) 8.6.Drop View ( 2 )
8.2.Insert View ( 3 ) 8.7.Complex View ( 2 )
8.3.Modify View ( 3 ) 8.8.Filter View ( 9 )
8.4.Select View ( 3 ) 8.9.Materialized View ( 3 )
8.5.View Sturcutre ( 3 ) 8.10.Update View ( 2 )
9.Index
9.1.Create Index ( 18 ) 9.4.Modify Index ( 1 )
9.2.Drop Index ( 1 ) 9.5.Timing Index ( 1 )
9.3.Functional Index ( 4 ) 9.6.Alter Index ( 1 )
10.SQL Data Types
10.1.Introduction ( 2 ) 10.8.Date Type Convert ( 10 )
10.2.int ( 1 ) 10.9.Number ( 8 )
10.3.CHAR ( 2 ) 10.10.Time Interval ( 24 )
10.4.VARCHAR2 ( 17 ) 10.11.Timestamp Timezone ( 10 )
10.5.character Unicode ( 2 ) 10.12.Timestamp ( 8 )
10.6.Date ( 18 ) 10.13.Timezone ( 4 )
10.7.Date Format ( 55 )
11.Character String Functions
11.1.Introduction ( 2 ) 11.12.RPAD ( 10 )
11.2.ASCII ( 5 ) 11.13.LTRIM ( 3 )
11.3.CHR ( 2 ) 11.14.RTRIM ( 3 )
11.4.CONCAT ( 3 ) 11.15.TRIM ( 10 )
11.5.INITCAP ( 3 ) 11.16.REPLACE ( 6 )
11.6.INSTR ( 10 ) 11.17.SOUNDEX ( 2 )
11.7.unistr ( 1 ) 11.18.SUBSTR ( 15 )
11.8.LENGTH ( 4 ) 11.19.VSIZE ( 1 )
11.9.LOWER ( 3 ) 11.20.COMPOSE ( 1 )
11.10.UPPER ( 5 ) 11.21.CONTAINS ( 3 )
11.11.LPAD ( 6 ) 11.22.DUMP ( 2 )
12.Aggregate Functions
12.1.Introduction ( 4 ) 12.7.STDDEV ( 1 )
12.2.AVG ( 6 ) 12.8.SUM ( 6 )
12.3.COUNT ( 14 ) 12.9.VARIANCE ( 1 )
12.4.MAX ( 7 ) 12.10.Group By ( 3 )
12.5.MEDIAN ( 3 ) 12.11.Incorrect Usage ( 2 )
12.6.MIN ( 3 )
13.Date Timestamp Functions
13.1.Introduction ( 7 ) 13.14.NUMTOYMINTERVAL ( 3 )
13.2.ADD_MONTHS ( 11 ) 13.15.ROUND ( 8 )
13.3.CURRENT_DATE ( 1 ) 13.16.SESSIONTIMEZONE ( 1 )
13.4.CURRENT_TIMESTAMP ( 2 ) 13.17.SYSDATE ( 9 )
13.5.DBTIMEZONE ( 1 ) 13.18.SYSTIMESTAMP ( 1 )
13.6.EXTRACT ( 15 ) 13.19.SYS_EXTRACT_UTC ( 1 )
13.7.FROM_TZ ( 1 ) 13.20.TO_CHAR ( 13 )
13.8.LAST_DAY ( 6 ) 13.21.TO_DATE ( 16 )
13.9.LOCALTIMESTAMP ( 1 ) 13.22.TO_TIMESTAMP ( 1 )
13.10.MONTHS_BETWEEN ( 6 ) 13.23.TO_TIMESTAMP_TZ ( 5 )
13.11.NEW_TIME ( 3 ) 13.24.TRUNC ( 10 )
13.12.NEXT_DAY ( 7 ) 13.25.TZ_OFFSET ( 1 )
13.13.NUMTODSINTERVAL ( 5 ) 13.26.Date Arithmetic ( 6 )
14.Numerical Math Functions
14.1.Introduction ( 2 ) 14.14.Log ( 5 )
14.2.ABS ( 5 ) 14.15.MOD ( 9 )
14.3.ACOS ( 2 ) 14.16.POWER ( 5 )
14.4.ASIN ( 2 ) 14.17.ROUND ( 12 )
14.5.ATAN ( 2 ) 14.18.SIGN ( 5 )
14.6.ATAN2 ( 1 ) 14.19.SIN ( 5 )
14.7.BITAND ( 5 ) 14.20.SINH ( 3 )
14.8.CEIL ( 5 ) 14.21.SQRT ( 5 )
14.9.COS ( 3 ) 14.22.TAN ( 1 )
14.10.COSH ( 2 ) 14.23.TANH ( 3 )
14.11.EXP ( 3 ) 14.24.to_binary_double ( 1 )
14.12.FLOOR ( 8 ) 14.25.to_binary_float ( 1 )
14.13.LN ( 3 ) 14.26.TRUNC ( 8 )
15.Conversion Functions
15.1.Introduction ( 1 ) 15.8.TO_NUMBER ( 4 )
15.2.DECODE ( 11 ) 15.9.TRANSLATE ( 6 )
15.3.NVL ( 4 ) 15.10.Cast ( 12 )
15.4.NVL2 ( 4 ) 15.11.coalesce ( 2 )
15.5.ROWIDTOCHAR ( 1 ) 15.12.HEXTORAW ( 2 )
15.6.ROWIDTONCHAR ( 2 ) 15.13.TO_MULTI_BYTE ( 1 )
15.7.TO_CHAR ( 31 ) 15.14.TO_SINGLE_BYTE ( 1 )
16.Analytical Functions
16.1.Introduction ( 6 ) 16.18.NTILE ( 7 )
16.2.ROWNUM ( 4 ) 16.19.Nulls First Last ( 9 )
16.3.ROW_NUMBER ( 5 ) 16.20.OVER ( 11 )
16.4.RANK ( 7 ) 16.21.PERCENTILE_CONT ( 3 )
16.5.DENSE_RANK ( 8 ) 16.22.PERCENTILE_DISC ( 1 )
16.6.PERCENT_RANK ( 4 ) 16.23.RANGE ( 4 )
16.7.PARTITION_BY ( 7 ) 16.24.ROLLUP ( 12 )
16.8.CUBE ( 8 ) 16.25.MODEL ( 1 )
16.9.CUME_DIST ( 4 ) 16.26.SPREADSHEET ( 2 )
16.10.FIRST_VALUE ( 1 ) 16.27.Top ( 1 )
16.11.LAST_VALUE ( 1 ) 16.28.UNBOUNDED ( 2 )
16.12.Group by ( 1 ) 16.29.Window Functions ( 11 )
16.13.GROUPING ( 12 ) 16.30.HAVING ( 1 )
16.14.GROUPING_ID ( 3 ) 16.31.Order ( 1 )
16.15.First ( 1 ) 16.32.Table Joins ( 2 )
16.16.Last ( 1 ) 16.33.Where ( 1 )
16.17.LEAD LAG ( 5 )
17.Miscellaneous Functions
17.1.Introduction ( 1 ) 17.4.SQLERRM SQLCODE ( 3 )
17.2.GREATEST ( 4 ) 17.5.USER ( 1 )
17.3.LEAST ( 4 )
18.Regular Expressions Functions
18.1.Introduction ( 2 ) 18.7.Brackets ( 2 )
18.2.REGEXP_INSTR ( 14 ) 18.8.Bracketed Special Classes ( 14 )
18.3.REGEXP_LIKE ( 8 ) 18.9.OR ( 1 )
18.4.REGEXP_REPLACE ( 5 ) 18.10.Ranges ( 3 )
18.5.REGEXP_SUBSTR ( 6 ) 18.11.Repitition ( 7 )
18.6.Meta characters ( 20 )
19.Statistical Functions
19.1.AVG ( 1 ) 19.5.COVAR_POP ( 1 )
19.2.Corr ( 1 ) 19.6.COVAR_SAMP ( 1 )
19.3.Corr_K ( 3 ) 19.7.Cume_Dist ( 1 )
19.4.Corr_S ( 3 ) 19.8.MEDIAN ( 1 )
20.Linear Regression Functions
20.1.Introduction ( 1 ) 20.14.Stats_Mw_Test ( 4 )
20.2.REGR_AVGX ( 2 ) 20.15.STATS_ONE_WAY_ANOVA ( 8 )
20.3.REGR_AVGY ( 1 ) 20.16.STATS_T_TEST_INDEP ( 4 )
20.4.REGR_COUNT ( 2 ) 20.17.STATS_T_TEST_INDEPU ( 4 )
20.5.REGR_INTERCEPT ( 1 ) 20.18.STATS_T_TEST_ONE ( 4 )
20.6.REGR_R2 ( 1 ) 20.19.STATS_T_TEST_PAIRED ( 4 )
20.7.REGR_SLOPE ( 1 ) 20.20.STATS_WSR_TEST ( 4 )
20.8.REGR_SXX ( 1 ) 20.21.STDDEV ( 1 )
20.9.REGR_SXY ( 1 ) 20.22.STDDEV_POP ( 1 )
20.10.REGR_SYY ( 2 ) 20.23.STDDEV_SAMP ( 1 )
20.11.STATS_CROSSTAB ( 7 ) 20.24.VARIANCE ( 1 )
20.12.STATS_F_TEST ( 5 ) 20.25.VAR_POP ( 1 )
20.13.STATS_MODE ( 1 ) 20.26.VAR_SAMP ( 1 )
21.PL SQL Data Types
21.1.Introduction ( 9 ) 21.25.RAW ( 2 )
21.2.CHAR ( 8 ) 21.26.ROWID ( 1 )
21.3.CHAR Type Convert ( 5 ) 21.27.ROWTYPE ( 12 )
21.4.VARCHAR2 ( 18 ) 21.28.TYPE ( 7 )
21.5.CHAR VARCHAR2 Functions ( 14 ) 21.29.Column Type ( 2 )
21.6.DATE ( 22 ) 21.30.RECORD ( 18 )
21.7.TIMESTAMP ( 16 ) 21.31.Object ( 1 )
21.8.INTERVAL ( 15 ) 21.32.XMLTYPE ( 2 )
21.9.Data Type Conversion ( 2 ) 21.33.BINARY_INTEGER DOUBLE FLOAT ( 5 )
21.10.Date Functions ( 9 ) 21.34.MSLABEL ( 1 )
21.11.Date Type Convert ( 6 ) 21.35.CONSTANT ( 1 )
21.12.Convert to Date ( 1 ) 21.36.Subtype Custom Type ( 2 )
21.13.Boolean ( 10 ) 21.37.Variable Scope ( 3 )
21.14.Number ( 12 ) 21.38.AnyData ( 1 )
21.15.Convert to Number ( 3 ) 21.39.ANYTYPE ( 1 )
21.16.Number Format ( 1 ) 21.40.BLOB ( 4 )
21.17.Number Type Convert ( 1 ) 21.41.BFILE ( 3 )
21.18.Numeric Functions ( 1 ) 21.42.CLOB ( 6 )
21.19.PLS_INTEGER ( 3 ) 21.43.long ( 1 )
21.20.POSITIVE ( 2 ) 21.44.HttpUriType ( 1 )
21.21.INTEGER ( 1 ) 21.45.UROWID ( 1 )
21.22.LONG ( 2 ) 21.46.XMLType ( 3 )
21.23.NATURAL ( 1 ) 21.47.Unicode ( 3 )
21.24.NULL ( 11 ) 21.48.BINARY_DOUBLE ( 1 )
22.PL SQL Statements
22.1.IF ( 21 ) 22.13.Rollback Commit ( 6 )
22.2.CASE ( 12 ) 22.14.Binded variable ( 6 )
22.3.Loop ( 15 ) 22.15.Dynamic SQL ( 6 )
22.4.For LOOP ( 20 ) 22.16.Execute immediate ( 20 )
22.5.GOTO ( 6 ) 22.17.bulk collect ( 9 )
22.6.Labeled statement ( 2 ) 22.18.forall ( 6 )
22.7.While ( 11 ) 22.19.RETURNING ( 1 )
22.8.EXIT ( 8 ) 22.20.Timing a Statement ( 2 )
22.9.DDL Statement ( 1 ) 22.21.Autonomous Transaction ( 6 )
22.10.Select into ( 19 ) 22.22.Dynamic SQL statement ( 6 )
22.11.Named Block ( 1 ) 22.23.NULL ( 1 )
22.12.Nested Block ( 5 ) 22.24.RAISE ( 4 )
23.PL SQL Operators
23.1.Operators ( 12 ) 23.5.IS NULL ( 1 )
23.2.Operator Precedence ( 1 ) 23.6.Like ( 4 )
23.3.BETWEEN ( 2 ) 23.7.MOD ( 1 )
23.4.IN ( 3 )
24.PL SQL Programming
24.1.Introduction ( 18 ) 24.15.Handle Exception ( 18 )
24.2.Variable ( 3 ) 24.16.Raise Exception ( 11 )
24.3.Variable Scope ( 2 ) 24.17.raise_application_error ( 5 )
24.4.Code Block ( 9 ) 24.18.Your Exception ( 6 )
24.5.Decode ( 1 ) 24.19.SQL FOUND ( 1 )
24.6.TO CHAR ( 5 ) 24.20.SQL NOTFOUND ( 1 )
24.7.TO_DATE ( 5 ) 24.21.User Defined Exceptions ( 4 )
24.8.TO_NUMBER ( 3 ) 24.22.DBMS_OUTPUT ( 10 )
24.9.Delete ( 5 ) 24.23.DBMS_RANDOM ( 2 )
24.10.Insert ( 11 ) 24.24.DBMS_ROWID ( 1 )
24.11.Update ( 9 ) 24.25.dbms_stats ( 1 )
24.12.LEVEL ( 1 ) 24.26.dbms_utility ( 2 )
24.13.Error ( 2 ) 24.27.DBMS_WARNING ( 1 )
24.14.Exception ( 15 ) 24.28.ORA ( 17 )
25.Cursor
25.1.Introduction ( 13 ) 25.9.Explicit Cursor ( 2 )
25.2.Cursor Declaration ( 16 ) 25.10.Cursor for Update ( 5 )
25.3.Cursor Open ( 3 ) 25.11.Cursor Parameter ( 4 )
25.4.Fetch ( 17 ) 25.12.ref cursor ( 6 )
25.5.LOOP ( 10 ) 25.13.REFCURSOR ( 9 )
25.6.Close Cursor ( 6 ) 25.14.Cursor Attributes ( 9 )
25.7.Cursor Status ( 6 ) 25.15.refcursor ( 3 )
25.8.Implicit Cursor ( 18 ) 25.16.Cursor function ( 5 )
26.Collections
26.1.Introduction ( 3 ) 26.15.POWERMULTISET ( 1 )
26.2.Varray ( 28 ) 26.16.POWERMULTISET_BY_CARDINALITY ( 1 )
26.3.VARRAY Column ( 13 ) 26.17.IN ( 2 )
26.4.Varray_of Varchar2 ( 2 ) 26.18.IS A SET ( 1 )
26.5.Varray Methods ( 5 ) 26.19.IS EMPTY ( 2 )
26.6.Varray of Number ( 7 ) 26.20.IS NULL ( 1 )
26.7.Associative Arrays ( 23 ) 26.21.MEMBER OF ( 4 )
26.8.Nested Tables ( 9 ) 26.22.Table Collection Attributes ( 4 )
26.9.Nested Table Column ( 8 ) 26.23.Table of Number ( 22 )
26.10.CARDINALITY ( 3 ) 26.24.Table of Record ( 4 )
26.11.COLLECT ( 1 ) 26.25.Table of rowtype ( 3 )
26.12.SET ( 12 ) 26.26.Table of Type ( 6 )
26.13.SUBMULTISET ( 4 ) 26.27.Table of Varchar2 ( 8 )
26.14.MULTISET ( 1 )
27.Function Procedure Packages
27.1.Function ( 17 ) 27.15.IN Parameters ( 5 )
27.2.Nested Functions ( 2 ) 27.16.Out Parameters ( 4 )
27.3.Function Return ( 15 ) 27.17.IN OUT Parameters ( 2 )
27.4.Recursive Functions ( 2 ) 27.18.NOCOPY ( 5 )
27.5.Procedure ( 14 ) 27.19.Overloading ( 6 )
27.6.Create Procedure ( 8 ) 27.20.View Errors ( 1 )
27.7.Procedure Return ( 1 ) 27.21.Print Output ( 1 )
27.8.Update in Procedure ( 1 ) 27.22.Debug ( 2 )
27.9.Drop Procedure ( 1 ) 27.23.EXEC ( 2 )
27.10.Packages ( 24 ) 27.24.Show error ( 1 )
27.11.Package Body ( 13 ) 27.25.transaction ( 4 )
27.12.Package Variables ( 11 ) 27.26.Utility Function ( 20 )
27.13.Alter recompile ( 2 ) 27.27.Utility Package ( 10 )
27.14.Parameters ( 16 ) 27.28.Utility Procedure ( 8 )
28.Trigger
28.1.Introduction ( 9 ) 28.11.INSTEAD OF ( 3 )
28.2.Trigger ( 14 ) 28.12.Auidt Table ( 7 )
28.3.NEW OLD ( 9 ) 28.13.Schema Trigger ( 6 )
28.4.Row Level Trigger ( 4 ) 28.14.Database Level Trigger ( 6 )
28.5.Table level trigger ( 1 ) 28.15.Deleting ( 2 )
28.6.Before Event Trigger ( 11 ) 28.16.Inserting ( 3 )
28.7.After Event Trigger ( 7 ) 28.17.Updating ( 2 )
28.8.Disable Enable Trigger ( 4 ) 28.18.IS_DROP_COLUMN ( 1 )
28.9.Drop Trigger ( 2 ) 28.19.Trigger and Transaction ( 6 )
28.10.Trigger on a view ( 5 ) 28.20.Utility trigger ( 3 )
29.SQL PLUS Session Environment
29.1.Introduction ( 2 ) 29.33.analyze ( 14 )
29.2.Connect to Sql plus ( 2 ) 29.34.archived_log ( 1 )
29.3.SHOW ALL ( 7 ) 29.35.autocommit ( 1 )
29.4.COLUMN ( 22 ) 29.36.autotrace ( 12 )
29.5.Ttitle BTitle ( 3 ) 29.37.colsep ( 1 )
29.6.Break ( 9 ) 29.38.CONTEXT ( 4 )
29.7.COMPUTE ( 3 ) 29.39.current_schema ( 1 )
29.8.feedback ( 5 ) 29.40.define ( 2 )
29.9.echo ( 1 ) 29.41.markup ( 5 )
29.10.pause ( 5 ) 29.42.noprint ( 1 )
29.11.Line Size ( 3 ) 29.43.null ( 1 )
29.12.Page Size ( 6 ) 29.44.numwidth ( 1 )
29.13.Long ( 4 ) 29.45.plsql_ccflags ( 1 )
29.14.nls_currency ( 1 ) 29.46.PLSQL_DEBUG ( 1 )
29.15.nls_date_format ( 3 ) 29.47.plsql_line ( 1 )
29.16.nls_language ( 1 ) 29.48.PLSQL_OPTIMIZE_LEVEL ( 3 )
29.17.numformat ( 3 ) 29.49.plsql_warnings ( 2 )
29.18.clear screens ( 1 ) 29.50.prompt ( 1 )
29.19.SQL PLUS Editor ( 1 ) 29.51.query_rewrite_integrity ( 1 )
29.20.editor ( 3 ) 29.52.ratio_to_report ( 1 )
29.21.SQL_TRACE ( 1 ) 29.53.recyclebin ( 2 )
29.22.AUTOTRACE ( 7 ) 29.54.sort_area_size ( 1 )
29.23.OPTIMIZER_MODE ( 5 ) 29.55.spool ( 4 )
29.24.EXPLAIN PLAN ( 3 ) 29.56.sqlprompt ( 1 )
29.25.SCAN ( 1 ) 29.57.statname ( 1 )
29.26.serveroutput ( 6 ) 29.58.Usename ( 2 )
29.27.Timezone ( 5 ) 29.59.USER ( 2 )
29.28.Timing ( 3 ) 29.60.userenv ( 2 )
29.29.verify ( 1 ) 29.61.Variable ( 10 )
29.30.ACCEPT ( 3 ) 29.62.Session Variables ( 10 )
29.31.Binded Variables ( 3 ) 29.63.Skip ( 1 )
29.32.System User ( 4 ) 29.64.SYS_CONTEXT ( 3 )
30.System Tables Data Dictionary
30.1.access ( 1 ) 30.63.sesstat ( 1 )
30.2.all_col_comments ( 1 ) 30.64.sql ( 2 )
30.3.all_col_privs ( 1 ) 30.65.sqlarea ( 2 )
30.4.all_cons_columns ( 2 ) 30.66.sqltext ( 3 )
30.5.all_constraints ( 1 ) 30.67.statname ( 1 )
30.6.all_directories ( 1 ) 30.68.sys_nc_rowinfo ( 1 )
30.7.all_ind_columns ( 1 ) 30.69.tab ( 1 )
30.8.all_indexes ( 1 ) 30.70.temp_all_objects ( 1 )
30.9.all_nested_tables ( 1 ) 30.71.timer ( 1 )
30.10.all_objects ( 2 ) 30.72.timezone_names ( 1 )
30.11.all_procedures ( 1 ) 30.73.user_arguments ( 1 )
30.12.all_sequences ( 2 ) 30.74.user_col_comments ( 1 )
30.13.all_source ( 4 ) 30.75.user_col_privs_made ( 1 )
30.14.all_synonyms ( 2 ) 30.76.user_col_privs_recd ( 1 )
30.15.all_tab_columns ( 1 ) 30.77.user_cons_columns ( 2 )
30.16.all_tab_comments ( 1 ) 30.78.user_constraints ( 5 )
30.17.all_tab_privs ( 1 ) 30.79.user_dependencies ( 5 )
30.18.all_tables ( 2 ) 30.80.user_errors ( 3 )
30.19.all_triggers ( 1 ) 30.81.user_ind_columns ( 4 )
30.20.all_varrays ( 1 ) 30.82.user_indexes ( 2 )
30.21.all_views ( 2 ) 30.83.user_indextypes ( 1 )
30.22.cat ( 2 ) 30.84.user_jobs ( 1 )
30.23.col ( 2 ) 30.85.user_libraries ( 1 )
30.24.DB_OBJECT_CACHE ( 2 ) 30.86.user_method_params ( 1 )
30.25.db_pipes ( 1 ) 30.87.user_nested_tables ( 1 )
30.26.DBA_AUDIT_OBJECT ( 6 ) 30.88.user_object_size ( 1 )
30.27.DBA_AUDIT_SESSION ( 5 ) 30.89.user_object_tables ( 1 )
30.28.dba_ddl_locks ( 1 ) 30.90.user_objects ( 22 )
30.29.dba_dependencies ( 1 ) 30.91.user_operators ( 1 )
30.30.dba_extents ( 6 ) 30.92.user_plsql_object_settings ( 2 )
30.31.dba_data_files ( 1 ) 30.93.user_policies ( 1 )
30.32.DBA_FREE_SPACE ( 1 ) 30.94.user_procedures ( 4 )
30.33.dba_indexes ( 2 ) 30.95.user_segments ( 3 )
30.34.dba_jobs ( 1 ) 30.96.user_sequences ( 2 )
30.35.dba_jobs_running ( 1 ) 30.97.user_source ( 5 )
30.36.dba_locks ( 2 ) 30.98.user_stored_settings ( 1 )
30.37.dba_objects ( 5 ) 30.99.user_synonyms ( 1 )
30.38.DBA_OBJECT_SIZE ( 1 ) 30.100.user_sys_privs ( 1 )
30.39.dba_role_privs ( 2 ) 30.101.user_tab_columns ( 2 )
30.40.dba_sys_privs ( 3 ) 30.102.user_tab_comments ( 1 )
30.41.dba_tab_columns ( 1 ) 30.103.user_tab_privs_made ( 1 )
30.42.dba_tab_privs ( 4 ) 30.104.user_tab_privs_recd ( 1 )
30.43.dba_tables ( 2 ) 30.105.user_tables ( 5 )
30.44.dba_tablespaces ( 3 ) 30.106.user_triggers ( 3 )
30.45.dba_triggers ( 1 ) 30.107.user_types ( 1 )
30.46.dba_users ( 4 ) 30.108.user_updatable_columns ( 1 )
30.47.DICTIONARY ( 1 ) 30.109.user_varrays ( 1 )
30.48.dict_columns ( 1 ) 30.110.user_views ( 2 )
30.49.lock ( 1 ) 30.111.v_buffer_pool ( 1 )
30.50.logmnr_contents ( 1 ) 30.112.v_controlfile ( 1 )
30.51.nls_parameters ( 1 ) 30.113.V_DATAFILE ( 1 )
30.52.object_table ( 1 ) 30.114.v_dbfile ( 1 )
30.53.open_cursor ( 1 ) 30.115.V_INSTANCE ( 3 )
30.54.parameter ( 3 ) 30.116.v_lock ( 1 )
30.55.process ( 1 ) 30.117.v_log_history ( 1 )
30.56.role_sys_privs ( 1 ) 30.118.v_nls_parameters ( 1 )
30.57.session_context ( 1 ) 30.119.V_PARAMETER ( 1 )
30.58.rowcache ( 1 ) 30.120.V_SESSION ( 3 )
30.59.SESSION_LONGOPS ( 1 ) 30.121.V_SGA ( 1 )
30.60.session_privs ( 1 ) 30.122.v_sql ( 1 )
30.61.sess_io ( 1 ) 30.123.v_statistics_level ( 1 )
30.62.session ( 3 )
31.System Packages
31.1.DBMS_ALERT ( 7 ) 31.22.dbms_rls ( 5 )
31.2.dbms_application_info ( 7 ) 31.23.dbms_rowid ( 11 )
31.3.DBMS_AQ ( 1 ) 31.24.dbms_session ( 4 )
31.4.dbms_aqadm ( 2 ) 31.25.dbms_space ( 2 )
31.5.dbms_crypto ( 7 ) 31.26.DBMS_SQL ( 20 )
31.6.DBMS_DB_VERSION ( 1 ) 31.27.DBMS_STATS ( 10 )
31.7.DBMS_DDL ( 1 ) 31.28.DBMS_TRANSACTION ( 1 )
31.8.DBMS_DEBUG ( 1 ) 31.29.DBMS_TYPES ( 1 )
31.9.dbms_fga ( 1 ) 31.30.dbms_utility ( 13 )
31.10.dbms_java ( 1 ) 31.31.dbms_wm ( 1 )
31.11.DBMS_JOB ( 8 ) 31.32.dbms_xmlschema ( 1 )
31.12.DBMS_LOB ( 9 ) 31.33.File Read with UTL_FILE ( 4 )
31.13.dbms_lock ( 2 ) 31.34.owa_util ( 1 )
31.14.dbms_logmnr ( 4 ) 31.35.File Write with UTL_FILE ( 4 )
31.15.dbms_metadata ( 2 ) 31.36.system_privilege_map ( 1 )
31.16.dbms_obfuscation_toolkit ( 3 ) 31.37.HTP ( 11 )
31.17.DBMS_OUTPUT ( 11 ) 31.38.UTL_FILE ( 9 )
31.18.DBMS_PIPE ( 11 ) 31.39.utl_raw ( 6 )
31.19.dbms_preprocessor ( 2 ) 31.40.utl_smtp ( 2 )
31.20.DBMS_PROFILER ( 7 ) 31.41.utl_tcp ( 1 )
31.21.DBMS_RANDOM ( 2 )
32.Object Oriented
32.1.Object Type ( 24 ) 32.13.Delete ( 3 )
32.2.Constructor ( 6 ) 32.14.Update ( 3 )
32.3.Member Function ( 8 ) 32.15.CAST ( 5 )
32.4.type body ( 8 ) 32.16.THE ( 1 )
32.5.Type Inheritance ( 8 ) 32.17.VALUE Function ( 2 )
32.6.Object Instance ( 4 ) 32.18.DEREF function ( 1 )
32.7.Object Column ( 14 ) 32.19.table function ( 8 )
32.8.Object Reference Column ( 8 ) 32.20.Alter Type ( 2 )
32.9.Object Table ( 13 ) 32.21.Describe Type ( 2 )
32.10.Nested Object Table ( 10 ) 32.22.Drop Type ( 2 )
32.11.Select ( 10 ) 32.23.FINAL ( 1 )
32.12.Insert ( 11 )
33.XML
33.1.Introduction ( 8 ) 33.7.extract ( 3 )
33.2.Insert ( 3 ) 33.8.UPDATEXML ( 5 )
33.3.xmlelement ( 3 ) 33.9.xdburitype ( 2 )
33.4.XMLTYPE ( 11 ) 33.10.xmlattribute ( 2 )
33.5.extractvalue ( 3 ) 33.11.XPath ( 3 )
33.6.existsNode ( 6 )
34.Large Objects
34.1.Introduction ( 3 ) 34.7.REF function ( 1 )
34.2.BFILE ( 9 ) 34.8.to_clob ( 2 )
34.3.BLOB ( 12 ) 34.9.TO_LOB ( 2 )
34.4.CLOB ( 16 ) 34.10.EMPTY_BLOB ( 2 )
34.5.DIRECTORY ( 2 ) 34.11.EMPTY_CLOB ( 1 )
34.6.LONG ( 4 ) 34.12.bfilename ( 3 )
35.Transaction
35.1.Introduction ( 2 ) 35.4.SAVEPOINT ( 2 )
35.2.Commit ( 2 ) 35.5.Transaction Level ( 4 )
35.3.Rollback ( 1 ) 35.6.Flashbacks ( 6 )
36.User Privilege
36.1.Create User ( 10 ) 36.6.Password ( 2 )
36.2.User Permission ( 17 ) 36.7.Roles ( 21 )
36.3.Drop User ( 2 ) 36.8.Synonyms ( 10 )
36.4.Lock unlock ( 1 ) 36.9.System Privileges ( 6 )
36.5.Object Privileges ( 6 )

AltStyle によって変換されたページ (->オリジナル) /