Recent content by TMoore

Ok, it work in procedure window but not in usual sql window when I write some test and develop custom PL/SQL piece of code.

Hi One of the horrible thing is rewrite column in RECORD, VARRAY, for example: declare my_rec emp%ROWTYPE; begin select * into my_rec from emp; dbms_output.put_line( my_rec.

Marco it works fine in session window, but when I fire sql window and pass select sysdate from dual I see that in module I see pl/sql developer. How pass dbms_application code automaticly via login.sql file?

Hi guys I put this in AfterConnect.sql : BEGIN dbms_application_info.set_module(module_name => 'my_progs',action_name => 'none'); END; I works fine, but when I fire SQL Window it did not use AfterConnect.sql. How to change it, I know I can write this same statmement in SQL Window. cheers

Marco dev is best tool. I always advice to use it instead of froggy soft. Your product is simple, faster. For me, things that is missed is: - sql trace - reader/parser - statspack - reader/parser - full support of table feature - external tables, lob full support, compression - full support for MV

Hi guys When developer will support external tables?

Another great would be: Raport that I can execute in period time. I can gather time stats. I can be usefull. I should be possible to export to excel.

OK, it option export user objects. But in schema that is logged in. How to export all object from another user. I assume that user who use this has privilage for this.

1. Isn't this covered by Tools > Export User Objects? Ok but How can I dump sql in entire schema(tables, index, views, synonims, pl/sql structures)? Maybe you should add schema on main tree. And on all: tables, schema when i click right mouse key I should show possibilites export all objects.

>What you you expect as result of this both >queries ? It is one of the solution. I don't what to use second program window. I have 8 queries, each has 10 - line of code. > Auto-execute and Auto-select is good and also mark some sql and fire it. I can write union select but it costs much more...

Hi I wrote this: select count(1) from test; select * from test; developer hang on ';' character. How to solve this problem? Sometimes I have long script whitch can not union select.

I have 2 suggestion: 1. Add feature: Dump DDL for custom user and put it in file 2. Add if statment to formating raports, ex: if some value > 100 - highlight to red 3. Support for materialized view or snapshot

I downloaded version 5.1.3.704 and trial ends for 2 day. Can I uninstall it and install 5.1.4 with new period of trial? Option *for update* lock records!! it is not usefullf for me.

Hi all I download trial developer I have 2 question: 1. When I try to use command *copy to excel*, field type VARCHAR2 it convert to number in EXCEL so when I have '00004342' it convert to '4342'. How to prevent this?? 2. How to update, edit values, records in table after select command...