Recent content by sladek

Hi Marco, could you please try this? Create a table with two varchar columns and insert something like this: ROW COLUMN1 COLUMN2 1 aserkuef afdlkjewqlir 2 sdfkhdl"kljfd sdflkj"sfkj 3 "afkjewk sdfkjsed 4 sflkjwelk afdlkjel 5 dsfk"aflkje sdreiufk 6...

I have a problem with copy & paste the result of a query to Excel if the content of a cell begins with double-quotes (like "hello). Everything of the result between the first double-quote and the next double-quote (even - and that's the problem - if the next appearance of a double-quote is in...

That could be a solution for my problem. But maybe it's difficult to find the right tab for the selected statement. Because everytime i execute it, one parameter in the SELECT will have changed and in this case i don't want a new tab to be opened. Marco, can you add this to the "requested...

Hi, I'm testing the new version while still using v5 at work. I'd really like the feature to display the result of multiple statements in the SQL window. But i don't want to execute all of my statements at once, only the selected statement should be executed. I figure out, that enabling the...

Simply try the following select. The problem ist not really caused by the encoded text but by the leading double quotes. Execute the select and copy the result to Excel. select '"Text', 'hello', 'you" and me', 'test' from dual For me it produces ("Copy with Header") 4 cells with headings and...

Hi, some of the names we store in the database are encoded, so only special users can read the real name. These encoded names are very cryptic and sometimes I have problems copying the result of a select with such names to Excel. The table in Excel has fewer rows than the query result. It seems...

Before I stumbled on PL/SQL Developer at work we were using Vision:Explorer from Sterling Software (some of my colleagues still do). With this tool you can open Excel-sheets an save them as a table into the database (like a "create table as ... select" with an Excel-sheet as source). I'd like to...

I've found out 2 problems after installing 5.1.4: 1. Copying more than one line from clipboard to a command window will show only a line number (e.g. 8 if i copy seven lines) but not the text i'd copied. The copied statement is invisible but still executable. 2. Problems copying large amount of...