Hi,
I've raised a ticket for this but just wanted to check if anyone had found the same problem or a workaround.
I'm using DEFINE in a query block and the following works fine in SQLPlus, SQLDeveloper, TOAD but not in DbForge
DEFINE nowzz = 'TO_TIMESTAMP_TZ(''2021-3-17 12:33:8 +00:00'', ''YYYY-MM-DD HH24:MI:SS TZH:TZM'')';
SELECT &nowzz AS NowTime FROM dual;
If I run the above in DbForge I get
NOWTIME
-------
)
If I run the same in SQLPlus or SQL Developer I get
old:SELECT &nowzz AS NowTime FROM dual
new:SELECT TO_TIMESTAMP_TZ('2021-3-17 12:33:8 +00:00', 'YYYY-MM-DD HH24:MI:SS TZH:TZM') AS NowTime FROM dual
NOWTIME
--------------------------------
17-MAR-21 12.33.08.000000000 GMT
Anyone else found a similar issue?
DbForge doesn't handle DEFINE correctly
-
- Posts: 8
- Joined: Thu 01 Aug 2019 12:53
Re: DbForge doesn't handle DEFINE correctly
Just got a response from support who tell me they don't support any SQL Plus commands.
I'm now trying to find out why their website says differently given it's listed as a feature.
https://www.devart.com/dbforge/oracle/s ... pport.html
I'm now trying to find out why their website says differently given it's listed as a feature.
https://www.devart.com/dbforge/oracle/s ... pport.html