'Get elements of list having BYTE defined in brackets,

ALTER SESSION SET CURRENT_SCHEMA = ${KEY}_DATA;

CREATE TABLE ${KEY}_DATA.API_ACTUALS_FILTER
(  
    FILTERNAME VARCHAR2(1000 BYTE) NOT NULL ENABLE, 
    FILTER VARCHAR2(1000 BYTE),
    API_ACTUALS_ID VARCHAR2(1000 BYTE
)


CREATE TABLE ${KEY}_DATA.API_ACTUALS_FILTERISATION
(  
    FILTERNAME VARCHAR(200 BYTE NOT NULL ENABLE, 
    FILTER VARCHAR(2000 BYTE), 
    API_ACTUALS_ID VARCHAR(3000 BYTE),
    FILTERs VARCHAR(2000 BYTE,
    
)

I am converting SQL file into a python list,i need to retrieve all the list elements have column datatype as VARCHAR or VARCHAR2 and length semantics as BYTE in python.

Example

VARCHAR2(100 BYTE)     VARCHAR(100 BYTE)


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source