Recent content by ckubitsc

Marco, with "Export to Excel with SQL statement" disabled the export works without error. Unfortunately, it is very handy to have the query exported automatically. Googling the character limit for an Excel cell gives me "32,767 characters" and I just realized that my query being 192829...

I've generated a pretty long query that produces some results I want to export to Excel. When I right-click on the results and select "Copy to Excel..." I get a pop-up window that has "Error" in the title bar, the query in the main window, and a button marked "OK". My results do not copy to...

Thank you, Marco. That's exactly what I was looking for (but didn't know it).

Has the option of tiling SQL Windows been removed? If not, can someone point me to the right spot on the ribbon? I just upgraded from 11.0.6.1796 to 12.0.2.1818 and I'm still at the search for everything (search the ribbon, search the manual, search the forum) Thanks.

I've stumbled upon a workaround for my problem. The blindingly obvious - replace one kind of comment for another! with Bob as (select 'one' Row_Num from Dual union select 'two' from Dual) select '/* tab=' || Row_Num || '*/ ' || 'select ' || 10 || ' "Query" from dual;' from Dual, Bob; The...

Yes, that is very similar. If you copy a single row from the text column it doesn't have the extra ".

I've written a query to generate a set of queries. My problem is that when I copy all the results each cell is surrounded by double quotes ("). If I only copy one cell I don't have this problem. Is there something I can do or set up differently to stop the double quotes from appearing? Here's...

Would it be possible to add separators (like Firefox can do in the bookmark list) as an option to the Object Browser? Right now I create a folder with the description of "--------------" but separators might take up less real estate while being a clearer division.

Have you tried the "Save Layout" under the "Window" menu item?

That brings me back to the original question then. How many queries (Ctrl-A) could I run in a single SQL Query window? Is there a limit?

Could you add this to the list of enhancement requests?

Thanks for the interesting suggestion. I eventually want the results copied to Excel - one query per tab. Can I do that from the Command Window?

If I run multiple queries from the SQL Query window the results for each query appear in separate tabs. How many queries can I run at once (or, phrased differently, how many tabs can I create at once)? As background - I've written a query to generate a set of queries. If I select all the...