Oracle SQL Developer - Full Course

preview_player
Показать описание
Learn the features that can help you work with your Oracle database better and faster
MySQL Database - Full Course from Zero to Hero

Oracle SQL Developer is currently the most popular tool among database developers and Oracle SQL learners, however, since it makes it so easy to start firing commands and querying a database, many people don't feel the need to investigate its features, and end up using only what is obvious, visible, and enabled by default.

If you are one of them, this course will help you get out of that group and start using Oracle SQL Developer more smartly.

Even if you have some time using the tool and are currently using some of its features, there's most likely something in this course that you don't know and can be helpful to you.

Learn the features that can help you work with your Oracle database better and faster:

Install and configure Oracle SQL Developer to run in your desired language and only with the features you need.
Create database connections and execute commands and scripts.
Display your results in a way that makes your work easier.
Use code templates and snippets to accelerate your work.
Export data in different formats and using different methods.
Some other useful and interesting things.

All Oracle SQL Developer features are free. Take advantage of them:

This course was created because there appears to be a pattern among Oracle SQL courses, regardless of the platform where they are taught: “If you are able to install it and connect to a database, you are good to go".

What's more: Experience shows that even developers who are already working with Oracle databases as part of their job, tend to not look for ways to work faster in SQL Developer, and usually only investigate features they don't currently use when it is strictly necessary for their jobs.

The goal of this course is to fill the gap most SQL courses leave about this great tool so that it can serve as a foundation if you are planning to learn Oracle SQL, and also to help you take advantage of the tool's features if you are already working with Oracle databases as part of your job.

Content and Overview:

The course includes more than 20 lectures, each one starting by showing you why you need it or how it can be helpful to you, and then proceeding to demonstrate how to enable it and/or use it.

There is usually one lecture per feature, so, if for any reason you are not interested in any of the included tips, you can simply skip it, and go directly to the one you want to learn about.

The course content will continue to be updated over time, to make sure you always know about the most important features available to you, as new versions of Oracle SQL Developer are released.

Learn these tips and apply them to your work, and you will not only be well prepared to learn SQL or work with it smartly, but will also enjoy being seen as an experienced and knowledgeable developer by your friends and peers.

#oracel #sql #database

Video source via:
Рекомендации по теме
Комментарии
Автор

@55:52 Using HTML

If you concatenate html tags into your select list so that they surround an expression, the output will actually provide an html output. Alternatively, you can just use the opening tags and leave out the closing tags in your concatenation and you will get the same result. This includes img tags with a src.

An example: SELECT '<html><font color = "red" face = "comic sans ms" size="6">'||table_name name,
FROM cat;

An interesting use case is that you can place html code into the 'Display Null Value as' bar located at Tools>Preferences then click Database and then click Advanced. This can allow you to display an html image for example when a NULL is present in your data.

awakened
Автор

@48:40 Useful Shortcuts

1. Hotkey for SQL History is F8 or View>SQL History

From here you can move previous queries into your worksheet or remove them.

2. ctrl+space hotkey to fill in queries as you type them for table or column names.

3. ctrl+g hotkey to jump to a specific line in your worksheet

4. shift+f4 on object name in worksheet to give a floating window with even more information than the DESCRIBE command.
Using this hotkey on a stored procedure or function will give you its code in a new tab.

5. shift+f5 hotkey for moving to the next tab to your left.
shift+alt+f5 hotkey for moving to the next tab to your right

6. ctrl+tab+tab (hold ctrl and press tab twice while continuously holding ctrl) will take you to your last tab.
If you continue to hold ctrl after you have pressed tab twice you will get a list of all of your tabs so you can toggle through them with tab.

awakened
Автор

@53:12 Useful Shortcuts 2

ctrl+shift+' hotkey for toggling between UPPER, LOWER, and INITCAP on highlighted text in worksheet

ctrl + / hotkey for commenting in or out your line or highlighted lines of code in worksheet

alt + pagedown and alt+pageup hotkeys for moving between worksheet and results grid (very helpful for when copying and pasting results while running queries)

awakened
Автор

@16:54 Using the Linegutter

You can see your line and column at the bottom right of your SQL Developer window.

Right click in your worksheet to the left of the dotted lines to turn on line gutter (toggle line numbers)

Instead of trying to highlight a query with your mouse on the query text, start your click and drag at the line number in which your query begins and drag to highlight.

If you go to Tools<Preferences:

Click + Code Editor and then Line Gutter to see that this feature mentioned above is selected by default.

awakened
Автор

@1:02:51 Displaying Gauges

Here is a hard-coded example (you can also do this dynamically since there is string involved):

SELECT column_name1, 'SQL:GAUGE:<min>:<max>:<low_threshold>:<high_threshold>:<values_the_gauge_needs>', column_name2;

In the above example, the min is the minimum value you want your gauge (a bar graph) to display and max is the maximum value. Low and High Threshold control where the bar graph will be colored to represent ranges of values in the low and high range and, if you leave an interval between the low and high threshold, there will be a third area colored in between the low and high threshold.

values_the_gauge_needs is the expression you will use to feed the gauge values to display. For example:

SELECT last_name, || salary, column_name2;

awakened
Автор

@29:32 Exporting Data

Simply highlighting the data and then using ctrl+c and pasting somewhere with ctrl+v does not give you the column header.

Instead, if you use ctrl+shift+c, you will also copy the column headers.

You can also right click on any selection of data and then click 'Export" and this will bring up the export wizard.

You can then export as your data as insert, html, or pdf. HTML and INSERT are two examples that can be particularly useful in some use cases.

Also, you can insert a /* csv */, /* html */, /* insert */ and other comments immediately before your column list in the SELECT list and then run a script in order to output in the format of your comment's keyword. You can use any keyword from the export wizard except pdf and excel.

If you use a spool command followed by a file path immediately before a SELECT statement as per the paragraph immediately above this one, you can export this as a file on a machine.

Finally, you can export a table by right-clicking it in the connections window and clicking export.

awakened
Автор

@8:53 Creating database connections

Connection color important to consider

1521 is default port of the Oracle listener

xe is default instance name of express edition

test before save

awakened
Автор

@19:05 Formatting Code

ctrl+f7 hotkey to auto format all of your code in your worksheet (or highlight specific query(-ies) first before using the hotkey to only format a select amount of code)

You may not like the autoformat above so you can change the output of ctrl+F7 by doing the following:

Tools>Preference:

Click Database (or possibly Code Editor and, if so, then click 'Format' and then 'Advanced Format')

Then click SQL Formatter and then Oracle Formatter.

awakened
Автор

@46:30 Navigation Filtering and Zebra Pattern

Tools<Preferences

Then click Database and then Navigation Filter. You can limit the visible options in the Connections window now.

For Zebra Pattern, Tools<Preferences

Then click Database and then worksheet and enable zebra pattern.

awakened
Автор

Wonderful set of tips and tricks, but I have a question about SQL Editor Code Templates in Version 19.2.1.247 of SQL developer. Even though I tried to do a ssfw and parameterized it, it is not working the same way as you have shown us in this video with older version. I am unable to jump between parameters via Tab and I need to use my mouse to actually point over each parameter and manually fill it... Do you know what might have changed with the newer version of the SQL developer...? Thanks.

murathp
Автор

Simply Awesome, these are really helpful, thank you :)

girishdadi
Автор

This is the best Oracle SQL tutorial 👍

SachinKumar-cttj
Автор

Great lecture, thank you so much for your work! I have a question, when I use oracle sql at work, why tables showing filtered and not showing? How to make them appear?

danayoung
Автор

Awesome, amazing... Thank's a lot for share this!

josemicorrea
Автор

Hello,
I can not cennect to database. Where did you create username and passwrd? Thank you!

aydinbaysoz
Автор

Thank you for all these tips! Awesome!

bellmorada
Автор

You can also use F9 to execute statements instead of ctr + enter

zeroxcrusher
Автор

Great, This is what i expected. Thanks 👌

shobanbabu
Автор

The energy you have is contageous! I was excited when you were

astrolite.
Автор

excellent tutorial.. why so less view? highly recommend!!!! thank you sir. God

xxllyyss