Look at this
Case 1:
DECLARE
CURSOR X
IS
SELECT
DECODE
(dummmy,
'x',
'y',
'z')
FROM DUAL ;
-- toad will NOT do anything!!!!
BEGIN
FOR X
IN
1
..
2
LOOP
NULL;
END
LOOP;
END;
Case 2:
SELECT
DECODE
(dummmy,
'x',
'y',
'z')
FROM DUAL;
-- toad will do the refactor.
From: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]
Sent: Monday, July 07, 2014 12:25
To: toadoraclebeta@toadworld.com
Subject: Re: [Toad for Oracle - Beta Discussion Forum] Lots of issues with 12.6 beta ( 64 bit for me)
Re: Lots of issues with 12.6 beta ( 64 bit for me)
Reply by Michael Staszewski
Also for #4 the statement has to be valid. If this statement is the one throwing ORA-907 missing right parenthesis exception then it will not work
for you. Is the statement you're trying to convert valid? If so please send me the SQL or one that reproduces the issue.
On 07/07/2014 12:07 PM, steven.kladitis_687 wrote:
RE: Lots of issues with 12.6 beta ( 64 bit for me)
Reply by steven.kladitis_687
- Toad takes forever to tell me there is an issue.
- Please tell me how to do it the correct way. I highlight the whole statement and say convert decode to case. Should I just highlight the whole decode statement.
I have lots of sql with tons of decode in one sql statement. I assumed I did not even have to highlight anything. Just click convert decode to case and
the whole sql statement would get processed.
Same for convert oracle to ansi.
2 was incorrect. It does do what it is supposed to do.
JJ
From: Michael Staszewski [mailto:bounce-mstaszew@toadworld.com]
Sent: Monday, July 07, 2014 11:46
To: toadoraclebeta@toadworld.com
Subject: Re: [Toad for Oracle - Beta Discussion Forum] Lots of issues with 12.6 beta ( 64 bit for me)
Re: Lots of issues with 12.6 beta ( 64 bit for me)
Reply by Michael Staszewski
I looked at items 2, 4, and 5 and I'm unable to reproduce.
For 2 and 4 do you have a single SQL statement in the editor tab or are there multiple? If multiple does it make a difference if you paste your SQL to a new tab as the only statement?
#2: Make sure you do not have an ORDER BY within the subquery. It is not valid SQL to have it there. Example: (wrong - throws ORA-907 missing right paren) select decode(empno, 1, 2, 3) from emp where deptno in (select deptno from dept order by 1).
#4: If you can send me a sample statement to reproduce that would help.
michael.staszewski@quest.com. I tried with select decode(empno, 1, 2, 3) from emp where deptno in (select deptno from dept) order by 1 and it converted the statement correctly.
#5: I assume that you mean within Toad you are trying to connect to the forums. Do you get any error message or anything indicating failure? If not how long are you letting it try? A timeout exception may be thrown after some time. Can you connect from the
website directly?
Michael
On 07/07/2014 11:33 AM, steven.kladitis_687 wrote:
Lots of issues with 12.6 beta ( 64 bit for me)
Thread created by steven.kladitis_687
- Unless I am logged into shcema with table , I get NO results.
- Using a subquery with -> order by <- in it causes toad to tell me I am missing a paran somewhere.
- During compare you are unable to check only columns. ( The box is there but you can not check it! ).
- Unable to use any feature like cahnge decoe to case. Oracle to ani joins.... no longer do anything.
5 unable to log into toad world. Not sure wht is going on her. I have other programs that get to there forums. ( we do have a firewall )
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
The information contained in this e-mail and in any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any
review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. This message has been scanned for known computer viruses.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum
Flag
this post as spam/abuse.
The information contained in this e-mail and in any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. This message has been scanned for known computer viruses.
