Recent content by jschmied

Hi! I just got the same problem ... Just not forget the fix. Thanks Juergen

Hi! I've used to type some lines in without caring about formatting and then hit a hotkey to format these lines....

Hi! Is there any relese date planed? I've to kill the plsqldev about 10 times a day. It's quite anoying. I'd take any prerelease ;) Thanks! Juergen

Hi! I'm voting for fixing this also... Thanks! PS: Changing PCTUSED for all kind of Tables does not work for me. (Put value in, APPLY, REFRESH, value is gone) J

Hi! with a as (select * from dual), b as (select * from a), c as (select * from b) select * from c; says: "could not parse text" Greetings Juergen

I just tried with the version 7.0.3.1123 ----- with tis_data as (select aenderungsart, ereignis_date, external_key_fk from ereignis e, ereignis_tis et where e.ereignis_pk = et.ereignis_fk) SELECT * FROM tis_data d1, tis_data d2 WHERE d1.aenderungsart = 2 AND d2.aenderungsart = 3 AND...

Hi! The Beautifier doesnt understand this syntax: with maxpk as (select max(pk) as pk from event_log t where event_text like '%Gleichamberg%') SELECT * FROM event_log e WHERE e.pk BETWEEN (SELECT pk FROM maxpk) - 1 AND (SELECT pk FROM maxpk) + 1 greetings Juergen

Hi! I have a table wiht a self-referencing FK (tree-like). The diagram windows does not display the relationship as a red line. Thanks Juergen

Hi! The following cases are still not fixed in the last version: - INSERT ALL is handled wrong - CASE WHEN ELSE END within a SELECT Statement is handled wrong could you fix this in one of the next releases? Thanks Juergen

PS: xmltype.createxml(cy.xmldata).extract('/RESPONSE') gives a xmltype back. xmltype.createxml(cy.xmldata).extract('/RESPONSE').getStringVal() works.

Hi! The PLSQL Developer just closes without any message boxes. No log is written. juergen

Hi! The following Statement crashes the PLSQL-Developer: SELECT cy.xmldata, xmltype.createxml(cy.xmldata).extract('/RESPONSE') FROM billing b cy.xmldata is a clob column. No debuglog is written. Thanks J

Hi! Can you support the table-compression attribute in the edit-table dialog? Thanks! Juergen

Hi! I can't give the write privilege to a directory in the 'Edit User'->'Object privileges' dialog. Think it's just forgotten there. Thanks Juergen

It would be very nice if the beautifier could process a script in the command window too. juergen