1SQL::Translator::ParserU:s:eOrraCcolnet(r3i)buted Perl DSoQcLu:m:eTnrtaantsiloantor::Parser::Oracle(3)
2
3
4

NAME

6       SQL::Translator::Parser::Oracle - parser for Oracle
7

SYNOPSIS

9         use SQL::Translator;
10         use SQL::Translator::Parser::Oracle;
11
12         my $translator = SQL::Translator->new;
13         $translator->parser("SQL::Translator::Parser::Oracle");
14

DESCRIPTION

16       From http://www.ss64.com/ora/table_c.html:
17
18        CREATE [GLOBAL TEMPORARY] TABLE [schema.]table (tbl_defs,...)
19            [ON COMMIT {DELETE|PRESERVE} ROWS]
20                [storage_options | CLUSTER cluster_name (col1, col2,... )
21                   | ORGANIZATION {HEAP [storage_options]
22                   | INDEX idx_organized_tbl_clause}]
23                      [LOB_storage_clause][varray_clause][nested_storage_clause]
24                          partitioning_options
25                             [[NO]CACHE] [[NO]MONITORING] [PARALLEL parallel_clause]
26                                [ENABLE enable_clause | DISABLE disable_clause]
27                                    [AS subquery]
28
29       tbl_defs:
30          column datatype [DEFAULT expr] [column_constraint(s)]
31          table_ref_constraint
32
33       storage_options:
34          PCTFREE int
35          PCTUSED int
36          INITTRANS int
37          MAXTRANS int
38          STORAGE storage_clause
39          TABLESPACE tablespace
40          [LOGGING|NOLOGGING]
41
42       idx_organized_tbl_clause:
43          storage_option(s) [PCTTHRESHOLD int]
44            [COMPRESS int|NOCOMPRESS]
45                [ [INCLUDING column_name] OVERFLOW [storage_option(s)] ]
46
47       nested_storage_clause:
48          NESTED TABLE nested_item STORE AS storage_table
49             [RETURN AS {LOCATOR|VALUE} ]
50
51       partitioning_options:
52          Partition_clause {ENABLE|DISABLE} ROW MOVEMENT
53
54       Column Constraints (http://www.ss64.com/ora/clause_constraint_col.html)
55
56          CONSTRAINT constrnt_name {UNIQUE|PRIMARY KEY} constrnt_state
57
58          CONSTRAINT constrnt_name CHECK(condition) constrnt_state
59
60          CONSTRAINT constrnt_name [NOT] NULL constrnt_state
61
62          CONSTRAINT constrnt_name REFERENCES [schema.]table[(column)]
63             [ON DELETE {CASCADE|SET NULL}] constrnt_state
64
65       constrnt_state
66           [[NOT] DEFERRABLE] [INITIALLY {IMMEDIATE|DEFERRED}]
67              [RELY | NORELY] [USING INDEX using_index_clause]
68                 [ENABLE|DISABLE] [VALIDATE|NOVALIDATE]
69                     [EXCEPTIONS INTO [schema.]table]
70
71       Note that probably not all of the above syntax is supported, but the
72       grammar was altered to better handle the syntax created by DDL::Oracle.
73

AUTHOR

75       Ken Youens-Clark <kclark@cpan.org>.
76

SEE ALSO

78       SQL::Translator, Parse::RecDescent, DDL::Oracle.
79
80
81
82perl v5.36.0                      2023-02-27SQL::Translator::Parser::Oracle(3)
Impressum