Recent content by ashish_mistry

Thanks Marco, I was aware of the feature but that is exactly what i do not want to do as it may be too risky with 20-30 windows/editors open It would be good to have this feature for Explain plan windows, and maybe debug test windows too esp. explain plan, would be good to have say an explain...

Hi, The issue I am facing is that I would want to spawn new windows in an existing session of my editor this is why : 1) Explain plan shown by plsql developer is mostly never correct if there are underlying materlized views as the explain window opens in a new session and I cannot execute any...

Alright they are there, thank God for that, So i figure Jobs folder is reserved for DBMS scheduler Jobs... i was afraid it was because of some installation over the older version issue U Rock Claus - Ashish

Strange no matter whatever you do .. Jobs are not listed under the Browser Folder "Jobs" Tried, Current User , provided actual owner, all Objects where there are actally several jobs owned by the schema PLSQL developer version 8.0.0.1480 DB Version : Oracle 9i Thanks, Ashish

Hi Marco, Is it not going to be considered as a bug and should the license not cover it? Partitions and Subpartitions have been in oracle for ages Plsql developer does not even list the partitions tab in this case, giving no indication that the table is partitioned even, altleast a message...

PlSQL developer Version 7.1.5.1398 Hi, Plsql developer does not display the partitions or subpartition information in the table edit window,the View sql also does not generate the exact table script where subpartitions are involved. Hope this will be patched/fixed and wont have to wait for my...

Hi Marco, Yes ... I tried to understand what the problem was in the last few days It does take 10-15 seconds if the focus goes to that value after quite some time say half hour to one hour Once listed... if I immediately navigate to the insert template then there is no delay and is displayed...

Hi, Is there some way to disable the "Insert template" option in the editor pop up menu As I have a lot of templates (50+ MB) and also on a network drive every time i right click the editor and the focus unintentionally goes to Insert Template Option there is a delay/pause of 10-15 seconds...

Yep Marco, a lot of schemas each being restricted to what it can do and access, external interfaces, governing schemas, data loading transformations, etc one of the apps has about 7 Meanwhile I had a re-attempted starting the instance with 'desktop=dev' parameter just to check if I could close...

Marco my mate

Hi, Though there are several new features that I would like in PLSQL developer. This one is really the most needed I would like to see a "Save Desktop" or "Save Desktop As" feature I have been using PLSQL developer for about 7 years now, recovery after a crash has never been a problem, but of...

Sry for the late reply was away for a while and then has some forum logon issues Also to add the output of my query above that gives the date values in the format desired - i.e. to_char(date, 'DD-MON-YYYY') --------------------------------------------------------------------- EFFDT...

Try having a table with date as 01-Jan-2100 .. eg i had a table ps_job with effdt as thedate field SELECT ps_job.effdt, to_char(ps_job.effdt,'DD-MON-YYYY'), count(*) FROM ps_job WHERE ps_job.effdt >= to_date('01-JAN-2009', 'DD-MON-RRRR') group by ps_job.effdt the PLSQL...