我在sqlserver中得语句是这样的!
declare @i int
@i=1
IF(@i='-1')
SELECT
*
FROM TBTAX_INVOICE ta
LEFT JOIN TBORG_BASEUNIT c1
ON c1.flID = ta.FLORGID
LEFT JOIN TBTAX_PROJECTS c2
ON c2.flID = ta.flProjectID
WHERE
ta.flprojectID IS NULL
and ta.flState in ('')
and ta.flMode in ('')
and ta.flType in ('')
else
SELECT
*
FROM TBTAX_INVOICE ta
LEFT JOIN TBORG_BASEUNIT c1
ON c1.flID = ta.FLORGID
LEFT JOIN TBTAX_PROJECTS c2
ON c2.flID = ta.flProjectID
WHERE
ta.flprojectID=''
and ta.flState in ('')
and ta.flMode in ('')
and ta.flType in ('')那么怎么把它转化为oracle中得语句呢? 求改高人指点!
declare @i int
@i=1
IF(@i='-1')
SELECT
*
FROM TBTAX_INVOICE ta
LEFT JOIN TBORG_BASEUNIT c1
ON c1.flID = ta.FLORGID
LEFT JOIN TBTAX_PROJECTS c2
ON c2.flID = ta.flProjectID
WHERE
ta.flprojectID IS NULL
and ta.flState in ('')
and ta.flMode in ('')
and ta.flType in ('')
else
SELECT
*
FROM TBTAX_INVOICE ta
LEFT JOIN TBORG_BASEUNIT c1
ON c1.flID = ta.FLORGID
LEFT JOIN TBTAX_PROJECTS c2
ON c2.flID = ta.flProjectID
WHERE
ta.flprojectID=''
and ta.flState in ('')
and ta.flMode in ('')
and ta.flType in ('')那么怎么把它转化为oracle中得语句呢? 求改高人指点!
解决方案 »
- 刚学oracle,问个新手问题
- 刚装的oracle_10g 发现scott 用户不存在
- oracleXE的HTMLDB问题
- 请教,如何把oracle的数据导到sql server2000中(vb中实现)
- 公司将来一台Oracle服务器,要送一个人去培训,公司银子不多,请问该参加什么样的培训啊?目前大家都只会SQL Server,谢谢啊!
- oracle中,对一个表T_CMPP_RECEIVE 操作,出现如下错误?谁能解释一下原因???
- UTL_FILE求救
- VB中ADO调用返回记录集的存储过程的问题:如何写cmdtext?(provider=oracle Provider for oledb)
- Oracle中的用户管理问题?(入门级)
- 用尽的 Resultset 这个提示?
- oracel 不同数据库之间的切换
- oracle 条件判断问题
i INT;
TYPE ref_cursor_type IS REF CURSOR;
ref_cursor ref_cursor_type;
BEGIN
i := 1;
IF i = -1
THEN
OPEN ref_cursor FOR
SELECT *
FROM tbtax_invoice ta LEFT JOIN tborg_baseunit c1
ON c1.flid = ta.florgid
LEFT JOIN tbtax_projects c2 ON c2.flid = ta.flprojectid
WHERE ta.flprojectid IS NULL
AND ta.flstate IN ('')
AND ta.flmode IN ('')
AND ta.fltype IN ('');
ELSE
OPEN ref_cursor FOR
SELECT *
FROM tbtax_invoice ta LEFT JOIN tborg_baseunit c1
ON c1.flid = ta.florgid
LEFT JOIN tbtax_projects c2 ON c2.flid = ta.flprojectid
WHERE ta.flprojectid = ''
AND ta.flstate IN ('')
AND ta.flmode IN ('')
AND ta.fltype IN ('');
END IF;
END;
i int := 1;
begin
IF(i = -1) then
/*
SELECT *
FROM TBTAX_INVOICE ta
LEFT JOIN TBORG_BASEUNIT c1 ON c1.flID = ta.FLORGID
LEFT JOIN TBTAX_PROJECTS c2 ON c2.flID = ta.flProjectID
WHERE ta.flprojectID IS NULL
and ta.flState in ('')
and ta.flMode in ('')
and ta.flType in ('')
*/
dbms_output.put_line('满足条件');
else
/*
SELECT *
FROM TBTAX_INVOICE ta
LEFT JOIN TBORG_BASEUNIT c1 ON c1.flID = ta.FLORGID
LEFT JOIN TBTAX_PROJECTS c2 ON c2.flID = ta.flProjectID
WHERE ta.flprojectID = ''
and ta.flState in ('')
and ta.flMode in ('')
and ta.flType in ('')
*/
dbms_output.put_line('不满足条件');
end if;
end;