Recent content by Stroeks

Ok, Found it out myself, use dba_views checked, and it worked.

Hello, I have a user with the following privileges (over a role) execute any procedure, select any dictionary (and some more) If i use the object browser to show me only the objects from another user, why do i not see the package bodies contents? I have the select any dictionary privilege, so...

Hello, Drop Table (right click on the Tablename) does not drop tables when there are lowercase characters in the tablename. create table "test" (id number); Try dropping it with the right click on the Tablename in the objectlist :( create table test (a varchar2(1)); Try dropping the...

Hello, PL/SQL-Developer Version 7.1.4.1390, Database 9i and 10G Wenn i create a table as follows: CREATE TABLE test ( id NUMBER(19), data BLOB , CONSTRAINT test_pk PRIMARY KEY (id) USING INDEX TABLESPACE INDEX01 ) LOB(data) STORE AS test_blob ( TABLESPACE DATA02 ENABLE...

Marco, Hope you had time to see the Netherlands - Sweden this weekend! greetings,

What do i have to do, to get no scientific notation in the command window when i do a select * from [TABLE] ? thx,

Hello Marco, Can you tell me why i can't use the execute wheel in command window when i'm disconnected? In my scripts the first command is to connect to a specific database. (pl/sql-developer 5.1.4) greetings, Leo Soepenberg

Hi, I am using PL/SQL developer 5.1.4. I found the SET DATEWIDTH command, but the result is a bit surprising to me: SET DATEWIDTH 20 select * from p12025.testen; ID DATUM ------------------------- -------------------- 1 13-06-2004 08:40i:23...

I am very interested, would like to have such a plugin!!

Marco Thnx, i already thought so, we have multiple homes here, so it answers my question. // Leo

Hello, I am using query reporter, but i get some unexpected results in the ordering. It seems that when i do an order by on a alfanumeric field, the order is not the same as in the same sql in plsql-developer. For example order by in Query reporter ignores case. An also a '.' (dot) does not...

Hello, I don't know where to put the sql or/and pl/sql i write to see it just like the reports in pl-sql developer. I want to see a name in the toolbar (or in one of the menus), (for example 'update emp table') and when i open it, my sql or plsql will be executed. I also would like to hide the...