变量声明的转换从Microsoft SQL Server 到 MySQL

Ispirer SQLWays数据库迁移软件
Informix变量声明的转换到Oracle

Informix DEFINE语句允许声明有一个数据类型的变量列表，在末尾指定。在Oracle您可以声明只一个变量与适当的数据类型。

SQLWays 转换Informix的DEFINE语句与变量列表到独立声明语句为每个变量在Oracle。

SQLWays 转换 Informix LIKE到Oracle %TYPE参数。

表格 21。变量声明转换的例如

Informix Oracle

create procedure with_multidef_stmt (var1 int)
define a, b, c int;
define d, e, f char(20);
let a = 10;
end procedure; create or replace procedure with_multidef_stmt (var1 int)
as
a int;
b int;
c int;
d char(20);
e char(20);
f char(20);
begin
set a := 10;
end;

create procedure with_LIKE (var1 int)
define i LIKE tab.c1;
define j,k LIKE tab.c2;
let i = 20;
end procedure; CREATE OR REPLACE PROCEDURE with_LIKE(var1
NUMBER)
AS
i tab.c1 %TYPE;
j tab.c2 %TYPE;
k tab.c2 %TYPE;
BEGIN
i := 20;
end;

create procedure with_LIKE1 (var1 LIKE tab.c1)
define i LIKE tab.c1;
define j,k LIKE tab.c2;
let i = 20;
end procedure; CREATE OR REPLACE PROCEDURE with_LIKE(var1 tab.c1
%TYPE)
AS
i tab.c1 %TYPE;
j tab.c2 %TYPE;
k tab.c2 %TYPE;
BEGIN
i := 20;
end;

Informix	Oracle
create procedure with_multidef_stmt (var1 int) define a, b, c int; define d, e, f char(20); let a = 10; end procedure;	create or replace procedure with_multidef_stmt (var1 int) as a int; b int; c int; d char(20); e char(20); f char(20); begin set a := 10; end;
create procedure with_LIKE (var1 int) define i LIKE tab.c1; define j,k LIKE tab.c2; let i = 20; end procedure;	CREATE OR REPLACE PROCEDURE with_LIKE(var1 NUMBER) AS i tab.c1 %TYPE; j tab.c2 %TYPE; k tab.c2 %TYPE; BEGIN i := 20; end;
create procedure with_LIKE1 (var1 LIKE tab.c1) define i LIKE tab.c1; define j,k LIKE tab.c2; let i = 20; end procedure;	CREATE OR REPLACE PROCEDURE with_LIKE(var1 tab.c1 %TYPE) AS i tab.c1 %TYPE; j tab.c2 %TYPE; k tab.c2 %TYPE; BEGIN i := 20; end;