Print Thread
Window wrongly rendered
#43243 01/31/12 01:50 PM
Joined: May 2011
Posts: 37
L
Member
OP Offline
Member
L
Joined: May 2011
Posts: 37
SQL Window. Paste code:

SQL Query
/*/
update dual
set    x='x'
/*/
select * 
from   dual
/**/
where dummy < '1'

And press Execute. Data part is wrongly rendered.

Everything is ok if commented out part is removed and code looks like below:

SQL Query
select * 
from   dual
/**/
where dummy < '1'

Program version: 9.0.4.1644


Best regards,
Lukasz
Re: Window wrongly rendered
Lukasz Indeka #43249 02/01/12 08:31 AM
Joined: Mar 2007
Posts: 210
Rostock, Germany
Member
Offline
Member
Joined: Mar 2007
Posts: 210
Rostock, Germany
Hi,

using /*/ is brute force ;-).

/*
update dual
set x='x'
*/
select *
from dual
/**/
where dummy < '1'


There is no shortcut for experience(d).

PL/SQL Developer Version 10+11+12, Query Reporter Version 3.2.0.300
Oracle 11g,12c
Windows Server 2003/2008
Windows 10 Professionel 64 bit



Re: Window wrongly rendered
Theod #43250 02/01/12 09:24 AM
Joined: Oct 2005
Posts: 587
Belgium
Member
Offline
Member
Joined: Oct 2005
Posts: 587
Belgium
Hi,

Very interesting wink

I have been able to simplify it a little more:

Code
/*/
y
*/
select * 
from dual

Roeland


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.042s Queries: 14 (0.012s) Memory: 2.5056 MB (Peak: 3.0420 MB) Data Comp: Off Server Time: 2024-05-18 19:52:17 UTC
Valid HTML 5 and Valid CSS