Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.
"datatype_oracle":
{
"ddl":
"""
CREATE TABLE Sample_Table (
Col_01 date,
Col_02 number(1),
Col_03 number(1,2),
Col_04 number,
Col_05 varchar2(3 char), -- character semantics
Col_06 varchar2(4 byte), -- byte semantics
Col_07 clob,
Col_08 nclob
);
""",
"database": DdlParse.DATABASE.oracle,
"table": {"schema": None, "name": "Sample_Table", "temp": False},
"columns": [
{"name": "Col_01", "type": "DATE", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_02", "type": "NUMBER", "length": 1, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_03", "type": "NUMBER", "length": 1, "scale": 2, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_04", "type": "NUMBER", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_05", "type": "VARCHAR2", "length": 3, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_06", "type": "VARCHAR2", "length": 4, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_07", "type": "CLOB", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
{"name": "Col_08", "type": "NCLOB", "length": None, "scale": None, "array_dimensional": 0, "is_unsigned": False, "is_zerofill": False, "not_null": False, "pk": False, "unique": False, "constraint": "", "description": None},
],
"bq_field": [
'{"name": "Col_01", "type": "DATETIME", "mode": "NULLABLE"}',
'{"name": "Col_02", "type": "INTEGER", "mode": "NULLABLE"}',
'{"name": "Col_03", "type": "FLOAT", "mode": "NULLABLE"}',
'{"name": "Col_04", "type": "NUMERIC", "mode": "NULLABLE"}',