Recent content by Clouds

Hi there, The beautifier is still not able to handle queries with UNION statements. When there are a couple of union statements, the beautifier takes way too much time. In cases where quite some UNIONS are used (let's say 25) the beautifier apparently locks up for hours (I don't wait that...

Never mind this topic...bug was already fixed in newer version....

Sit tight for now....reading relase notes for newer versions made me realise it's probably already solved...checking new version now...

Hi, I'm trying to import data from a text file into the db using the text importer. When I specify an SQL-function for a column, using # to replace the data (as the example shows), an error will be thrown since the # is replaced with nothing (null)...It doesn't matter which SQL-function I...

As far as I know, this only happens if the preceding column has length 1.

I support this request :-) Isn't it possible to have the code assistant use another session so that it can still function while a query is running?

I have experienced problems with the beautifier too... There are some things the beautifier does not like: - Nested CASE-statements wil have the beautifier do nothing at all, except for setting the status bar to something like 'could not parse text'. - Multiple unions will surely KILL...try...

Richard, Since I had some bugs to beat last minute before I released version 1.0, I decided to skip to 1.1, which includes the options you like to see. Posted it today to support.

Richard, Would this be useful to you?: - If there is a connection on startup, the windows are created immediately. - If there is no connection on startup, windows will not be created until the first connection is made. Or should it be possible to set this differently for each window? Fire at...

Uli, This is fixed in the new version. These messages are now in the splash-screen. I guess it can be downloaded soon. Richard, I haven't thought of that because I always use commandline parameters to automatically logon. It's not in this new version, but I will look into it. (PS: Your email...

Hi Marco (and all others), I created a plugin that allows users to have files opened or new windows created at startup. Last week I sent it to support by email, but it might not have been spotted yet (or I am being impatient :-) Current version does have decent configuration possibilities...

End each query with a semicolon ( ;) When executing, the query where the cursor currently is, will be executed. This query will also be highlighted then. hth [This message has been edited by Clouds (edited 05 September 2003).]

'DayOfWeek' is not found in the Oracle HTML Tutorials I think you mean SELECT to_char(SYSDATE,'DAY') FROM dual or SELECT to_char(SYSDATE,'D') FROM dual HTH ------------------ Clouds

ORA-00600 internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string] Cause: This is the generic internal error number for Oracle program exceptions. It indicates that a process has encountered a low-level, unexpected condition. Causes of this...

Thank you in advance! And sorry again for my impatience PL/SQL Developer just r0xx0rz...it's far better than the lousy query tool that came with the information-system we have here! ------------------ Clouds