20 Tips for Oracle SQL Developer (To Save You Time)

preview_player
Показать описание

Oracle SQL Developer is a popular SQL editor for working with Oracle databases. It lets you write SQL and see the results of your queries pretty easily.

It's also got a range of features that you can adjust to make working with SQL Developer a lot easier.

In this video, I've demonstrated 20 tips on how you can better use SQL developer. These are simple things like keyboard shortcuts or features that aren't well known but can make your life easier.

You can use the timestamps below to navigate to sections of the video.

Feel free to leave a comment below if you have any questions.

Timestamps:
00:00 Start
00:19 Tip 1 - New Worksheet shortcut
01:07 Tip 2 - Block Selection
02:25 Tip 3 - Export data with Output Hints
03:37 Tip 4 - Quickly format your code
04:48 Tip 5 - Quickly open Preferences
05:21 Tip 6 - Split window
06:57 Tip 7 - Navigate tabs
07:29 Tip 8 - Code completion
08:10 Tip 9 - Show results in new tab
08:50 Tip 10 - Colour-code connections
09:53 Tip 11 - Run statement with keyboard
10:30 Tip 12 - Enable line numbers
11:08 Tip 13 - View past statements
11:33 Tip 14 - Filter results without re-running the query
12:22 Tip 15 - Disable single-click object properties
13:03 Tip 16 - Filter the Navigation Tree
13:57 Tip 17 - Use the Schema Browser
14:36 Tip 18 - Run SQL at startup
15:15 Tip 19 - Disable unused features
15:59 Tip 20 - Disable the Welcome page
Рекомендации по теме
Комментарии
Автор

My mind was blown several times watching this video. Thank You!!!

demikoo
Автор

Im starting my first IT job as a PL/SQL developer and this video is a life saver, Thank you!!

salvaddd
Автор

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

flashflair
Автор

CRazy how one can use a product for many years and never fully know it. You have given me some helpful insights, thank you

severtone
Автор

You made me fall in love with SQL. Thanks a lot

essayloopwritingservices
Автор

Finally found about block selection which I needed them early!

viliuxsas
Автор

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.

SinskariBoiguys
Автор

Very useful information, Gracias for content..

charansamudrala
Автор

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.

edsonandrade
Автор

How do you extract results (including the column names) from a stored procedure which output is a sys refcursor?

JL-qcgq
Автор

Thanks a lot! Is there a keyboard shortcut to hide the result grid, Like the Microsoft SQL Server Management Studio's Ctrl+R?

gabrielfigueiredodecarvalh
Автор

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.

bubbudubbu
Автор

Amazing video.. Thanks.. Pls make one for pgadmin too..

goldgold
Автор

Do you have tips on exporting queries faster?

danayoung
Автор

sql developer is real pain whenever you import/export huge data especially into excel/csv format. it literally hangs and locks everything - crazy.

enockoloo