Recent content by denmarkdev

Hi. We have a licens for DOA 3.4.6.1 and like to use the OracleMonitor. 1. Will it work with version 2.1 from herehttps://www.allroundautomations.com/oramon.exe? If not where do I find a compatible version? 2. Do I need another licens? 3. Where is the sample code to register the monitor...

Would it be a idea to query DBA_TAB_PRIVS when logged in as sys, so we see all grants on a object?

How does PL/SQL Dev retrieve the roles under table->mytable->Granted to users? How do I ensure that I see every role granted on a table (also if also granted to other users)?

Is it me or is the version slower than my old version 8.x? How do I disable the "Connections Windows" appearing on startup? Thanks for a good product.

thanks

Lots of my colleagues forget the schema name because of this! Off course I don

I know. But I'm always connected as the owner and then I do not get the schema name. I find it cumbersome to log in as e.g. sys user to get the alter SQL with the schema name. Could it be added as an option?

When I'm doing an "Edit table" and then using "View SQL" to see the alter SQL I'll like it to always prefix it with schema name. Is this possible?

Marco, i really like to here you opinion on this.

Any plans of using a big decimal class to avoid these issues? Still I don't get why Number(28,10) and Number(28,15) gives different results? In Oracle it is exact 495.96. In booth cases PL/SQL Developer is casting it into a double. If the number cannot be represented in a double, then both...

Thanks.

Hi Marco That was also my guess. But how come there isn't any precision loss when using Number or Number(28,10)? Is there any side effect by using "Number fields to_char"? If not, why isn't it checked by default?

The data type Number(28,15) is sometimes unprecise when selected from PL/SQL developer. -- Create table create table NUMBERTEST ( c1 number, c2 NUMBER(28,15), c3 NUMBER(28,10) ); insert into NUMBERTEST select 495.96, 495.96, 495.96 from dual; select c1, c2, c3...

Hi, The tool "Export User Objects" is great for exporting tables, triggers, procedures etc as sql alter scripts. I'll really like to do this from the command line. Is this possible with PL/SQL Developer?