Recent content by jto

hi, it would be nice to have the possibility to have multiple beautifier settings, each linked to its own keyboard shortcut. Reason - personal preferences differ but all source submitted to GIT repository should be formatted in the same way. As far as I know this is not currently possible, or is...

Hi again, installation of latest Nvidia driver solved the issue, everything is now smooth and quick regardless the window size - as it's suppose to be. I'm sorry for bothering you with this... have a good day J.

hello again, regarding the speed of switching between windows I mentioned above - I've just noticed there is a big difference if the PL SQL Developer window is maximized or not. When maximized, the response time for Ctrl+Tab is slow. When the window is not maximized the switch between windows is...

hi, I've been using version 9 for a few weeks now and there are some observations I'd like to share with you. First of all, thanks for the continuous development and improvements, PLSQL Developer really is a very good program which I've been using since version 7 on daily bases! I used version 8...

Version=1 RightMargin=80 Indent=2 UseTabCharacter=FALSE TabCharacterSize=2 AlignDeclarationGroups=TRUE AlignAssignmentGroups=TRUE KeywordCase=2 IdentifierCase=3 UseSpecialCase=TRUE ItemList.Format=1 ItemList.Align=TRUE ItemList.CommaAfter=TRUE ItemList.AtLeftMargin=FALSE EmptyLines=1...

Hello, this query below "kills" beautifier. select country_code, From_Date, To_Date, Info from (select country_code, sales_date as From_Date, case when Next_Diff = 1 then Lead(sales_date) Over(partition by country_code order...

yep, if I switch it off, everything is compiled without any problem. now of course the question - how can I make it run with the debug info? regards

hello, I've experienced the same problem but only on one database. PLSQL Dev 7.0.0.1050 Oracle Client 10.1.0.4 Db version 10.1.0.4 - no problems Db version 9.2.0.6 - one db - no problems, another one exactly the same behaviour as you have described. there is nothing in the database log files...

you are right - it's SmartEd. Sorry for the accusal! ;) best regards Jiri

Hello, I've just experienced incorred SQL editor behaviour in PL/SQL Developer Version 6.0.5.926 (MBCS) xxxxxx - 10 user license Windows XP version 6.0 (build 2600) Service Pack 2 Test case 1, open SQL window (or test window...) 2, write: select '1','2' from dual 3, mark the characters...

hello again Marco, I suppose this is caused by the same bug as mentioned above but it might not be... if you create view with column name(s) defined in quotation marks, e.g. create or replace view test ("My test") as select dummy from dual then extracted DDL looks like create or replace view...

well I can't recreate all FBIs in our production databases... best regards Jiri

ok. It's probably related to the same code but to be on the safe side - the same behaviour can be observed in "Edit table" screen on the Indexes tab. regards Jiri

Hello, I have tried the following: create table TEST_FBI ( UNIQUE_ID NUMBER(16) ); create index FBI on TEST_FBI bitand(UNIQUE_ID, 4); create index FBI2 on TEST_FBI decode(BITAND(UNIQUE_ID,4), 0, 1, NULL); in PL/SQL Developer Version 6.0.4.906 (MBCS) Windows XP version 6.0 (build 2600) Service...

Hello, I've found a small bug related to table/view columns completion in 6.0.4.906 (full version). Example create view test as select dummy "My test" from dual then if you type test. in editor, the 'my test' is displayed and if you select it it's pasted without quotation marks and in...