sqlglot.dialects.oracle

16class Oracle(Dialect):
17    ALIAS_POST_TABLESAMPLE = True
18    LOCKING_READS_SUPPORTED = True
19    TABLESAMPLE_SIZE_IS_PERCENT = True
20    NULL_ORDERING = "nulls_are_large"
21    ON_CONDITION_EMPTY_BEFORE_ERROR = False
22    ALTER_TABLE_ADD_REQUIRED_FOR_EACH_COLUMN = False
23    DISABLES_ALIAS_REF_EXPANSION = True
24
25    # See section 8: https://docs.oracle.com/cd/A97630_01/server.920/a96540/sql_elements9a.htm
26    NORMALIZATION_STRATEGY = NormalizationStrategy.UPPERCASE
27
28    # https://docs.oracle.com/database/121/SQLRF/sql_elements004.htm#SQLRF00212
29    # https://docs.python.org/3/library/datetime.html#strftime-and-strptime-format-codes
30    TIME_MAPPING = {
31        "D": "%u",  # Day of week (1-7)
32        "DAY": "%A",  # name of day
33        "DD": "%d",  # day of month (1-31)
34        "DDD": "%j",  # day of year (1-366)
35        "DY": "%a",  # abbreviated name of day
36        "HH": "%I",  # Hour of day (1-12)
37        "HH12": "%I",  # alias for HH
38        "HH24": "%H",  # Hour of day (0-23)
39        "IW": "%V",  # Calendar week of year (1-52 or 1-53), as defined by the ISO 8601 standard
40        "MI": "%M",  # Minute (0-59)
41        "MM": "%m",  # Month (01-12; January = 01)
42        "MON": "%b",  # Abbreviated name of month
43        "MONTH": "%B",  # Name of month
44        "SS": "%S",  # Second (0-59)
45        "WW": "%W",  # Week of year (1-53)
46        "YY": "%y",  # 15
47        "YYYY": "%Y",  # 2015
48        "FF6": "%f",  # only 6 digits are supported in python formats
49    }
50
51    PSEUDOCOLUMNS = {"ROWNUM", "ROWID", "OBJECT_ID", "OBJECT_VALUE", "LEVEL"}
52
53    def can_quote(self, identifier: exp.Identifier, identify: str | bool = "safe") -> bool:
54        # Disable quoting for pseudocolumns as it may break queries e.g
55        # `WHERE "ROWNUM" = ...` does not work but `WHERE ROWNUM = ...` does
56        return (
57            identifier.quoted or not isinstance(identifier.parent, exp.Pseudocolumn)
58        ) and super().can_quote(identifier, identify=identify)
59
60    class Tokenizer(tokens.Tokenizer):
61        VAR_SINGLE_TOKENS = {"@", "$", "#"}
62
63        UNICODE_STRINGS = [
64            (prefix + q, q)
65            for q in t.cast(list[str], tokens.Tokenizer.QUOTES)
66            for prefix in ("U", "u")
67        ]
68
69        NESTED_COMMENTS = False
70
71        KEYWORDS = {
72            **tokens.Tokenizer.KEYWORDS,
73            "(+)": TokenType.JOIN_MARKER,
74            "BINARY_DOUBLE": TokenType.DOUBLE,
75            "BINARY_FLOAT": TokenType.FLOAT,
76            "BULK COLLECT INTO": TokenType.BULK_COLLECT_INTO,
77            "COLUMNS": TokenType.COLUMN,
78            "MATCH_RECOGNIZE": TokenType.MATCH_RECOGNIZE,
79            "MINUS": TokenType.EXCEPT,
80            "NVARCHAR2": TokenType.NVARCHAR,
81            "ORDER SIBLINGS BY": TokenType.ORDER_SIBLINGS_BY,
82            "SAMPLE": TokenType.TABLE_SAMPLE,
83            "START": TokenType.BEGIN,
84            "TOP": TokenType.TOP,
85            "VARCHAR2": TokenType.VARCHAR,
86            "SYSTIMESTAMP": TokenType.SYSTIMESTAMP,
87        }
88
89    Parser = OracleParser
90
91    Generator = OracleGenerator

60    class Tokenizer(tokens.Tokenizer):
61        VAR_SINGLE_TOKENS = {"@", "$", "#"}
62
63        UNICODE_STRINGS = [
64            (prefix + q, q)
65            for q in t.cast(list[str], tokens.Tokenizer.QUOTES)
66            for prefix in ("U", "u")
67        ]
68
69        NESTED_COMMENTS = False
70
71        KEYWORDS = {
72            **tokens.Tokenizer.KEYWORDS,
73            "(+)": TokenType.JOIN_MARKER,
74            "BINARY_DOUBLE": TokenType.DOUBLE,
75            "BINARY_FLOAT": TokenType.FLOAT,
76            "BULK COLLECT INTO": TokenType.BULK_COLLECT_INTO,
77            "COLUMNS": TokenType.COLUMN,
78            "MATCH_RECOGNIZE": TokenType.MATCH_RECOGNIZE,
79            "MINUS": TokenType.EXCEPT,
80            "NVARCHAR2": TokenType.NVARCHAR,
81            "ORDER SIBLINGS BY": TokenType.ORDER_SIBLINGS_BY,
82            "SAMPLE": TokenType.TABLE_SAMPLE,
83            "START": TokenType.BEGIN,
84            "TOP": TokenType.TOP,
85            "VARCHAR2": TokenType.VARCHAR,
86            "SYSTIMESTAMP": TokenType.SYSTIMESTAMP,
87        }