Oracle 的SQL 代碼轉成SQL Server 代碼，

2008-04-15 09:10:26 73 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SQL Server中查询ORACLE的数据通过在MS SQL Server设置链接服务器而访问Oracle数据库数据的简单例程阅读详情



CREATE OR REPLACE FUNCTION SFCS.PARSING_TYPE(OLD_SN IN VARCHAR2,NEW_SN OUT VARCHAR2,PRINT_CODE_PATH OUT VARCHAR2)

RETURN VARCHAR2 IS S1 NUMBER;SN1 VARCHAR2(4);SN2 VARCHAR2(7);SN3 VARCHAR2(6);

BEGIN S1:=LENGTH(OLD_SN);

  IF S1=29 THEN SN1:=SUBSTR(OLD_SN,13,4);

	              SN2:=SUBSTR(OLD_SN,17,7);

								SN3:=SUBSTR(OLD_SN,25,5);

                NEW_SN:=SN1||SN2||SN3;

  ELSIF S1=30 THEN SN1:=SUBSTR(OLD_SN,13,4);

	                 SN2:=SUBSTR(OLD_SN,17,7);

									 SN3:=SUBSTR(OLD_SN,25,5);

                   NEW_SN:=SN1||SN2||SN3;

  else

NEW_SN:=old_sn;

end if;

  PRINT_CODE_PATH:='C:\WINNT\MITAC_APP\BARCODE\DMD-3.TXT';

END;

...全文