Do you want to save time while using SQL Developer? Get my Timesaver Guide to Oracle SQL Developer here: databasestar.mykajabi.com/lpkj-timesaver-sqldeveloper/?
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.
Do you want to save time while using SQL Developer? Get my Timesaver Guide to Oracle SQL Developer here: databasestar.mykajabi.com/lpkj-timesaver-sqldeveloper/?
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!
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!
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.
Finally found about block selection which I needed them early!
Great, yeah it's a helpful feature!
You made me fall in love with SQL. Thanks a lot
Happy to hear that!
Thanks for it. It´s really interesting and helpfullly
I’m glad it helped!
VERY USEFUL VID, THANKS SR
You're welcome
Thank you so mutch for this video. this tips It'll be very important for my learning.
Glad it was helpful!
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!
Very useful information, Gracias for content..
Thanks!
Thank You Sir for tips and Tricks 👍
Glad you found them useful!
Thank you, very much appreciated 🙏
Glad you like the video!
very very informative thanks alot.
Glad it was helpful!
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.
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.
usefull tips thank you dear
Thanks!
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!
Amazing video.. Thanks.. Pls make one for pgadmin too..
Thanks! Good idea.
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.
Nice video
Thanks!
Thanks.
No problem!
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.