I'm pretty new to using the SQL Developer extension to VSCode.
I'm trying to generate a bunch of text from my database, and then copy/paste the output into a text editor. I'm finding that if I do that, the system has a penchant for wanting to Excel-ify the data, forcing quotation marks to be escaped as doubled quotation marks “” instead of ", surrounding each line in quotation marks, etc. Is there a way to just get the raw text into the clipboard so I can use it?
As well, I was hoping to use the old-school mechanism of using “set serveroutput on size unlimited” and do a bunch of dbms_output.put_line calls within an anonymous block to generate my text. Though the code executes for making that happen, I can't seem to find where that output goes. It's not appearing in the Output, Terminal, or Script Output panes of VSCode.
BTW, when I tried to export my code using HTML output form and Text form, it ran into other errors. While the query would run fine when showing data in tabular form, exporting to HTML would give me
Error starting at line : 3 in command -
and eventually
SQL Error: ORA-00933: SQL command not properly ended
00933. 00000 - "unexpected keyword at or near %s"