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.
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.
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.
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.
Im starting my first IT job as a PL/SQL developer and this video is a life saver, Thank you!!
Glad it was helpful!
I know SQL cmd,PLSQL cmd ,oracle sql,MySQL ,postgresql what other skill should have to work in PLSQL developer??
What exactly you do in company ???and how??
My mind was blown several times watching this video. Thank You!!!
Glad you enjoyed it!
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
Yeah it's very handy! I use it in several other editors.
CRazy how one can use a product for many years and never fully know it. You have given me some helpful insights, thank you
Glad it was helpful!
Finally found about block selection which I needed them early!
Great, yeah it's a helpful feature!
Thank you so mutch for this video. this tips It'll be very important for my learning.
Glad it was helpful!
You made me fall in love with SQL. Thanks a lot
Happy to hear that!
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.
Thanks, that's good to know!
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.
Hmm I'm not sure if you can actually. You can open multiple packages at once, in different tabs, but you would have to scroll the list each time.
VERY USEFUL VID, THANKS SR
You're welcome
Thanks a lot! Is there a keyboard shortcut to hide the result grid, Like the Microsoft SQL Server Management Studio's Ctrl+R?
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.
Very useful information, Gracias for content..
Thanks!
Thank You Sir for tips and Tricks 👍
Glad you found them useful!
How do you extract results (including the column names) from a stored procedure which output is a sys refcursor?
Oh I'm not sure. I haven't worked with sys refcursors very much recently.
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.
That would be ahelpful feature. I'm not sure how to do it unfortunately!
Thank you, very much appreciated 🙏
Glad you like the video!
Amazing video.. Thanks.. Pls make one for pgadmin too..
Thanks! Good idea.
usefull tips thank you dear
Thanks!
very very informative thanks alot.
Glad it was helpful!
Thanks.
No problem!
Nice video
Thanks!
Do you have tips on exporting queries faster?
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.
sql developer is real pain whenever you import/export huge data especially into excel/csv format. it literally hangs and locks everything - crazy.
Yeah, I've found it can be slow when doing this. That's annoying that it locks :(
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.