Get Column name and data type information from Table Create DDL files. And set each getting information to 'DECLARE　variable_name　data_type'

Oracle:

CREATE TABLE type_tb
(
   num_col1    FLOAT,
   ts_col      TIMESTAMP
);

DECLARE
    credit  float;
    type_tb1   type_tb%ROWTYPE;
BEGIN
    credit := 3;
END;

HiRDB:

CREATE TABLE type_tb 
(
   num_col1    FLOAT,
   ts_col      TIMESTAMP
);

CREATE PROCEDURE sp_rowtype()
BEGIN
   DECLARE credit FLOAT;
   DECLARE SWV_TYPE_TB1_NUM_COL1 FLOAT;
   DECLARE SWV_TYPE_TB1_TS_COL TIMESTAMP;  
   SET credit = 3;
   END;
END_PROC