Recent content by Kengoo.ru

Doesn't PL/SQL Developer support correct syntax highlighting of quoted literals? Writing in SQL or Program window: declare str varchar2(3000) := q'[Hello, I'm a 'string' :)]'; begin dbms_output.put_line(str); end; Code is syntaxically correct, but highlighting fails. It's too bad because...

Yes, possibly it's the same! As I could see in Oracle traces, PL/SQL Developer adressed quite strange ROWID which had nothing similar with the actual one... And the traces of tests with usual table and an IOT do differ: with usual table Developer does one more query: select /*+ rule */...

Hi, developers! I've noticed I can't use in-place data editor with index-organized tables. Test case: create table test_table ( a number(10) not null, b number(10) not null, constraint tt_PK primary key (a,b) ) organization index; -- non-IOTs work fine! insert into test_table values...