I wish I knew block selection years ago. So many years spent adding ',' to each line or using notepad to replace or excel to create the columns etc. Blown away
One feature you’d like is improved backup. It has become very simple to spare your work in the tool. Before this patch we were developers were permitted to save around hundred articulations as a matter of course. But now you set aside to 500 explanations in the addition to the new feature of Oracle DB, cloud services has improved the transferring information.
Hi, Thanks for the awesome tips. I am trying to duplicate the connection window on the left. Is it possible? Basically, I am trying to open multiple packages and tables in parallel and currently with 1 connection window, I have to scroll to packages and tables list each time.
really good tips. I'm also looking for some tip to keep the code format when copying and pasting and also keeping the colors in SQL editor. I looked for it hardly but it seems to be a feature that does not exist. I heard Toad has a setup where you copy using Rich Text. In case you know anything please also share.
Good question, I'm not sure. There's a list of keyboard shortcuts currently in SQL Developer in the Preferences window, and you can set a shortcut if it's in the list and none is applied.
you can do it via keyboard, but not easily, def not with a single keystroke. Limitation I hope to have fixed with our new version of SQL Dev coming later in 2023.
Exporting the results of queries? Not that I know of. There may be a command to save the results of a query to a text file or CSV file in SQL but I don't know off the top of my head.
When you export the results, the application runs the query again. If you want to avoid this, return all the results from the query BEFORE you do an export.
if it's a huge file, always convert it to CSV first, and then the memory footprint and CPU requirements will be a FRACTION of what they'd be otherwise.