Ispirer Website Ispirer Capabilities - Oracle Migration Free Trial

Oracle %TYPE in Create Table DDL to HiRDB

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

Oracle:

CREATE TABLE type_tb 
(
   num_col1    FLOAT,
   ts_col      TIMESTAMP
 );
 
 DECLARE
 credit  float;
 debit   credit%TYPE;
 debit2  type_tb.ts_col%TYPE;
 BEGIN
    credit := 3;
 END;

HiRDB:

CREATE TABLE type_tb
(
   num_col1    FLOAT,
   ts_col      TIMESTAMP
);

CREATE PROCEDURE sp_types()
BEGIN
 DECLARE credit FLOAT;
 DECLARE debit FLOAT;
 DECLARE debit2 TIMESTAMP;
 SET credit = 3;
 END;
END_PROC

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.