Recent content by Anand

Hi, I un-installed PL/SQL Developer and deleted the folder that it was originally installed in. Then re-installed it from the same download I used for my previous install (which was version 7.1.4.1390). This obviously set all the preferences back to the default. I've since started applying the...

Looks like a complete re-install did the trick. Works as expected now. Thanks for you help Marco.

Hi, I'm afraid that makes no difference. Here's the output: Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0 Connected as homs SQL> set datewidth 30 SQL> select systimestamp from dual; SYSTIMESTAMP ------------ 14/02/2008 1 SQL> alter session set nls_timestamp_tz_format =...

Hi, I did try setting the format values for the column but it made no difference. Here's the output for setting it to 50: Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0 Connected as homs SQL> set col 50 SQL> alter session set nls_timestamp_tz_format = 'DD-MON-YYYY HH24.MI.SSXFF'...

Hi Marco, Thanks for the response. Unfortunately in my case it's worse in the command window (but this may be a column formatting issue like in the Oracle SQL*Plus client). Here's the output: Connected to Oracle9i Enterprise Edition Release 9.2.0.7.0 Connected as homs SQL> SQL> alter...

Hi, Has anyone encountered problems with the format of the timestamp column that is displayed in the SQL Window (or any other window) - in particular it not returning the milliseconds value? I cannot seem to get the format to show the same values as the NLS_TIMESTAMP_FORMAT (which is the...