在sqlserver里
(
select distinct OBJECT_ID2,OBJECT_ID1 from ITEMS_TREE )
union
( select 6066 as OBJECT_ID2,90 as OBJECT_ID1) 但在oracle里却不行,怎么在oracle里实现这样的功能啊
(
select distinct OBJECT_ID2,OBJECT_ID1 from ITEMS_TREE )
union
( select 6066 as OBJECT_ID2,90 as OBJECT_ID1) 但在oracle里却不行,怎么在oracle里实现这样的功能啊
例如:
MSSQL:select getdate()
oracle: select sysdate from dual;
后面加上from dual问题解决