我正在针对oracle数据库运行一个非常基本的select (不确定版本)。SELECT ROWNUM, * FROM ACCOUNTING WHERE ID = 123456 ORDER BY DATE我每次都得到同样的结果..。Error Source: System.Data.OracleClient
Error Message: ORA-00
当我对表X运行以下查询时( select rownum as rn, A.* from X as A order by A.IDdesc) where rn between0 我得到的结果是1 1 xxx3 4 zzzselect* from
( select rownum as rn, A.* from Y as
我需要编写oracle来使用rownum更新来自无关表的值的列。我不能让它工作:SET A.id = (SELECT B.id FROM table_2 B
WHERE A.rownum = B.rownum)只需要将值从列ID插入到另一个表。除了rownum之外,没有我可以用于联接的列。这有可能吗?
日安,这里有一个例子,我成功地改变了,但我并不真正理解它,我无法从谷歌找到它。= 001 AND T0.CHANNEL = 'CC') AS tname下面是我编辑后的SQL查询代码(成功地从Oracle获得数据):-00923: FROM keyword not found where expected .Thus,我