Oracle SQL Developer - Full Course
Вставка
- Опубліковано 28 лип 2024
- Learn the features that can help you work with your Oracle database better and faster
Oracle Tutorial | Oracle SQL Tutorial For Beginners ☞ morioh.com/p/cdd5588d4e8e
Oracle Foundations Associate Certification (PASS THE EXAM!) ☞ morioh.com/p/2e7316a54d06
MySQL Database - Full Course from Zero to Hero
☞ morioh.com/p/752aa713e91d
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:
@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)
@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 ''||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.
@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
Simply Awesome, these are really helpful, thank you :)
@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
@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.
@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:::::', 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, 'SQL:GAUGE:1:25000:2500:15000:' || salary, column_name2;
@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.
@46:30 Navigation Filtering and Zebra Pattern
Tools
@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.
Great, This is what i expected. Thanks 👌
Awesome, amazing... Thank's a lot for share this!
Well explained! Thank you!
Why does everyone skip the part of creating the local database?
This one worked for me:
how to set up server: ua-cam.com/video/GUpvXMHqe2U/v-deo.html
You tell
very useful info. Thanks!!!
This is the best Oracle SQL tutorial 👍
This info was really helpful. Thanks!
Useful information, thanks.
Thank you for all these tips! Awesome!
Thank you. My respects to you Sir.
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.
The energy you have is contageous! I was excited when you were
excellent tutorial.. why so less view? highly recommend!!!! thank you sir. God Job!!!!!
high recommend!!! Thank you!
Thank you so much, it was very useful.
Excellent delivery of shortcuts
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?
Sir, your presentation and selected topics for the video is really really great. Hats off. Thank you for the video.
Wow! 👏🏻👏🏻👏🏻 Great video sir.
❤️❤️ Awesome explanation.
Hello,
I can not cennect to database. Where did you create username and passwrd? Thank you!
Great👍...thanks for sharing this information
Awesome mate. just awesome.
@14:30 Executing Commands and Scripts
ctrl+enter hotkey for 'run statement'
A script is when you want to run two or more statements consecutively in one shot instead of individually.
F5 hotkey for 'run script'
You can reference an external script (one that is not present within your worksheet) by using:
@[then path to the file present on your maching].sql
Very good explanation
AMAZING TUTORAL!!!
You can also use F9 to execute statements instead of ctr + enter
Thank you very much
I like this video, thanks a ton for taking effort. Is it possible for new video using toad for oracle?
what an amazing course thanks man 👏
HI. CTRL+SPACE IS NOT WORKING WHEN WE ARE USING TEMPLATES.
Thanks , it's very useful
Thanks a ton
Excellent!
Great video!
hello, very good teacher....does exist an oracle sql course from same teacher?
Thank you
I have been using this video each time I wanna setup SQL since 2019 lmao
I keep getting error. The network adapter could not establish the connection.
Good explanation
Thanks by the tips!
I couldnt able to use spool and /*CSV*/* from Sql developer.
Do i need to change any settings?
How do I connect to an existing connection? I am failing to do so.
great video thanks
why when i press CTRL + SPACE. II still reamis ? my query goes wrong because that.
regards,
非常好！
Is a way to write a script for Data Pump Export in Oracle SQL developer?
Thank You.
Hello, i'm using a MacOS but never manage to make Oracle SQL Dev. tool working on it... i always get an error message when trying to add a DB. Like this: "The Network Adapter could not establish the connection"
How can I increase the buttons and the code line???
Hello, how can i just run a simple SQL Statement like " select getdate() "? The system show me a error "FROM is missing" . But Why
@11:39 Disabling Unneeded Features
Unneeded features affect application performance. Furthermore, it can affect security.
Tools>Features
Starting with Database, consider disabling the following:
Data Miner
Oracle OLAP
APEX listener Admin.
Change Management
Database Cart
RESTful Services Admin.
Spatial
Unit Test
XML Schema
Within Database Migrations, consider disabling the following:
Everything (if you don't work with migrations)
Within Version Control, consider disabling the following:
Everything (but Data Modeler depends on Subversion so may not be able to disable it)
Apply Changes
Tools menu will be shorter
cool. It is awesome.
I had sql developer tool working like a charm for years. Recently I got a new laptop and got sql developer installed and now it became too slow and it takes almost 30 minutes to run a simple select query. Do you see any configuration change could fix this issue?
Are connections actually separate databases - i.e. if I make a table in one connection, it doesn't seem to show up in another connection?
Hi,
How did you find out the Username and Password to connect to local host?
Hello Sir, I can't connect to the database like you showed. What is the password you entered? I entered the password of my oracle acc. Still unable to connect t9 database. Any other way to connect to local database?
how to fix
ORA-01017 invalid username/password; logon denied problem
Can anyone tell me which password should I use? I am beginner have no idea... I try but error came!
Is PL/SQL alternate to Oracle SQL Developer?
Having problem with my databases using other databases fields
hello my username and password work on the cli but not on sql developer plz answer ok
For creating "sys" connection what is the password
how can i solve this error ? Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection (CONNECTION_ID=GjNCEiZvSz67JdYsugt2/Q==)
Namaste
Oracle is offering free OCI database certifications till 28-Feb-2022
Where can we get username and password.Do we have to put randomly any username and password or we have to create it from somewhere!Please sir help me out
I need that information too.
I m not sure but I think it's the password, you put when you download/install oracle *database*
@@toonkinga284 I have used it but it dosent work
What is the password how we can get the password of any connection no one is showing the full method to create a connection
This is a my SQL course or oracle SQL 19 c
@24:15 Displaying NULLs in a special way
Tools>Preferences
Then click 'Database' and then 'Advanced'
Choose a color from the drop down 'Display Null Using Background Color'
what is password for sys? our machine password?
@42:00 Generating Relational Diagrams
First of all, you can see the details of a table by finding it in the connections window and clicking on it.
Alternatively, a hotkey for this is to hold down ctrl while clicking on the table's name within the worksheet window.
Within this details window there are a number of tabs that are helpful.
Clicking on the 'model' tab will provide a relational diagram of the given table and right clicking on one of the tables in this diagram will provide the option to 'show parent and child tables' which brings other tables that depend on that table into the diagram.
Another way to make a relational diagram is to click ViewImport>Data Dictionary and then clicking the connection you want and the objects you want to include.
Finally you can click File>Data Modeler>Print Diagram in order to create a file with your diagram for printing.
11:36
Thanks for the tips, its helps a lot!
I commented because I can't gave you 2 likes....lol
Real video begins @8:53
select /*html*/* from all_users; not working