Recent content by Invincible

  1. I

    Export table to sql inserts does not check for foreign keys to self

    Hi, Thanks it works very well. Is there an option to add N before strings, I want to export unicode strings to N'' format insted of '' f I found workaround export/import using pl/slq format
  2. I

    Export table to sql inserts does not check for foreign keys to self

    I have have a table with foreign key to itself but when I export it to sql inserts they are not ordered to satisfy the foreign key.
  3. I

    Bug: PL/SQL Developer doesn't display last char for nvarchar2

    PL/SQL Developer 8 doesn't display last char for nvarchar2 columns when "Unicode Enabled" is checked. Simple test : create table test_nvarchar ( test nvarchar2(10) ); insert into test_nvarchar values ('0123456789'); select * from test_nvarchar; Displays: '012345678'; If I uncheck...
  4. I

    ora-03127

    Fixed with Unicode Enabled (checked).
  5. I

    ora-03127

    I'm experience same problem - when my query returns CLOB result PL/SQL developer gives me an error "ORA-03127: no new operations allowed until the active operation ends" example : select dbms_metadata.get_ddl('VIEW','ALL_TABLES', 'SYS') from dual; it returns me only a part of clob. this works...
  6. I

    Feature Request: Option: "Stop on error" in SQL Window.

    It will nice to have option "Stop on error" for SQL Window. In command window I could write WHENEVER SQLERROR EXIT FAILURE; before sql script and this working fine but I can't use this method for SQL Window.
  7. I

    Request: New Feature - TNSNAMES.ora editor

    Could you develop a graphical editor for tnsnames.ora ? Now if I want to add another db connection I have to add it through text editor and there is a big chance for mistake.
See more
Back
Top