Oracle SQL Developer@OracleSQLDev

Oracle SQL Developer, 5+ million users strong and growing. Tips, tricks, & news #sqldev

 Redwood Shores, CA
Based in United States
oracle.com/technetwork/devel…
Joined July 2011
Join the thousands of others like David, who have already started using our new Extension for @code. Seamless #oracle #database development in your favorite text editor/IDE! Download today! social.ora.cl/6000TmiWy
When I saw this appear in the extensions marketplace, I felt grateful and relieved. I had been unable to use VS Code when working with PL/SQL for Oracle database. Other extensions did not support RADIUS authentication. I had to keep the Oracle SQL Developer IDE installed. Now, I work on all my projects using VS Code for everything.

ALT When I saw this appear in the extensions marketplace, I felt grateful and relieved. I had been unable to use VS Code when working with PL/SQL for Oracle database. Other extensions did not support RADIUS authentication. I had to keep the Oracle SQL Developer IDE installed. Now, I work on all my projects using VS Code for everything.

2
7
17
3,477
Installing #Oracle #SQL #Developer is now as easy as searching for 'sql-developer' in VS Code. social.ora.cl/6018rRdoj

ALT Installing Oracle SQL Developer is now as easy as searching for 'sql-developer' in VS Code.

7
58
163
29,057
Version 23.1.1 is now available for download with several critical bug fixes, including an updated Java 11 Home for Windows and Macs. social.ora.cl/6016RJNsE
4
33
139
11,765
Did you know? SQL Developer can not only generate DDL for any of your database objects, but it also includes a fully functional data modeling tool, which can also generate DDL! #oracle #developer #database
1
12
75
17,018
Tip: Let us help you remove the line numbers from your #SQL when you paste your code from SQLPlus/SQLcl! Hover over the line number, and then click on the 'Fix it' link. #oracle #developers

ALT Oracle SQL Developer helps you format and fix your SQL code, including just simple things like removing line numbers from when you've pasted it from SQLPlus or SQLcl.

4
21
4,281
Did you know you can view or more objects at once? Make sure your 1st table is 'pinned' before opening another. Once your two document tabs are open, you can mouse-drag the 2nd one to another part of the desktop, or right click, New Doc Tab Group. #oracle #database #sqldev
Oracle SQL Developer with the HR.EMPLOYEES and SH.SALES open for browsing at the same time. Use the Document Tab Groups feature to concurrently work on multiple objects or editors in the same desktop prsentation.

ALT Oracle SQL Developer with the HR.EMPLOYEES and SH.SALES open for browsing at the same time. Use the Document Tab Groups feature to concurrently work on multiple objects or editors in the same desktop prsentation.

6
2,104
Need help with your PL/SQL API calls? Ctrl+Space can help! Complete the program names and get a fingerprint of the required parameters and their types. #oracle #database #developers #plsql
1
4
8
2,904
Replying to @w7bugs @oraesque
Ok, that sounds like a parser issue... Can you check the log panel for errors, and also the Statements tab there for long running queries we might be running in the background
1
95
Take a few seconds, learn up to 5 new tricks in Oracle SQLDev! #oracle #sql #database #developer
2
10
34
4,958
Tip/Trick: SQL Text Expansion - what is your SQL REALLY doing? Hover over your SELECT, we'll show you! Example: the PIVOT clause, HT @connor_mc_d @DBoriented Available since...2014.
6
23
You can format how your code is decorated in the preferences. For example when you ctrl+click to open objects...
1
14
If you liked this tip, our product manager made a video that's dedicated to Data specific tips and tricks piped.video/watch?v=8-aUXY2n… See the chapters/video description for jump points.

Oracle SQL Developer Tips and Tricks: Data Edition

Tips and tricks for turbo charging your Oracle Database experience ...

youtube.com
2
7
SQLDev Tip: Dragging and dropping query results to build IN () lists. One of the little things you should know to save you LOTS of time and frustrating, repetitive keystrokes. #oracle #sql #database
6
15
84
Curious what jobs you have running? SQLDev Web can chart out your job history, making it easy to spot problems and conflicts. Drill into a specific job, or see all of your jobs for a given period of time. @thatjeffsmith talks more on this here - thatjeffsmith.com/archive/20…
9
A quick trick: asked and answered on @StackOverflow stackoverflow.com/a/71118881… Quickly adding quotes/commas to a list of values for a WHERE IN clause. #sql #sqldev
1
8
21
Our latest feature: reporting and visualizations for your DBMS_SCHEDULER jobs and chains. Product manager @thatjeffsmith takes you on a full tour here: social.ora.cl/6013KKmvl #oracle #database #sqldev

ALT animated gif - visualization of a dbms_sheduler job chain in Oracle Database

1
3
7
Replying to @haruzmile
Have you tried at least a dark them for your SQL Worksheet and Code Editors? draculatheme.com/oracle-sql-… On windows, you can also set your OS to dark mode and SQLDev to WIndows Look & Feel and it will adopt that
1
Jump straight to the SQL Developer Web Tips and Tricks here piped.video/X76H0FMsp-k?t=861
that Jeff Smith
@thatjeffsmith
22 Nov 2021
Slow start to the week? Here are 30 minutes of tips & tricks for all of our @OracleDatabase Tools - piped.video/watch?v=X76H0FMs… @OracleSQLDev @oraclesqlcl @OracleREST
3
8
Jump to piped.video/X76H0FMsp-k?t=245 for SQLDev tips!
that Jeff Smith
@thatjeffsmith
22 Nov 2021
Slow start to the week? Here are 30 minutes of tips & tricks for all of our @OracleDatabase Tools - piped.video/watch?v=X76H0FMs… @OracleSQLDev @oraclesqlcl @OracleREST
5
Replying to @DenesKubicek
We built a complete interface into SQL Developer Web itself. We recommend you start using that for your dev, doc, and testing.
1
2
adding group BYs as necessary is already there - just click on the Column in the advice hover area. More interesting is possibly the database being smart enough to know to add it for you - stay tuned :)
2
Replying to @iamanshultweet @Oracle @OracleDevs
A little tip for seeing your DBMS_OUTPUT... And then beware this is ok for debugging, but for true instrumentation, log messages in tables. A handy library - github.com/OraOpenSource/Log…
1
1
2
Using the Command Palette in Database Actions (Ctrl+Shift+P)..a tip via GIF! #oracle #code #sql #ide #sqldev
1
1
11
Did you know - no need for an Oracle Client, instant or installed, to use a tnsnames.ora file for connecting to @OracleDatabase ? @thatjeffsmith shows the way here: thatjeffsmith.com/archive/20…
7
25
Tuesday Tech Tip: Opening a database object is just a click away. Here are a few examples: a synonym, table, or a PL/SQL function - in your schema or someone else's. #oracle #sqldev #database #gif #100DaysofCode #plsql #sql
1
10
17
One of many new features in @OracleDatabase 21c - now available for Linux - SQL Macros - Learn how to use this innovation release feature here docs.oracle.com/en/database/… #oracle #sql
11
29
Friday Tech Tip: Our formatter 'hints' work across ALL of our tools! SELECT /*csv*/ * from employees; JSON, INSERTs, HTML, XML, Custom Delimiters...
3
14
45
Tip: We've taken many of the features in our desktop IDE and applied them to our Web interfaces. Here you have drag-and-drop support for executing PL/SQL in the Worksheet #oracle #plsql #CodeNewbies
6
27
You CANget your SQLID in SQL Developer today using the plan button in your toolbar -
Quickly browse your schema, tables, export to your favorite format! No desktop tools to install! Just install & configure @OracleREST for your Database! #oracle #database #gif
7
15
Replying to @MayaBhat1 @OracleDatabase @Oracle
Enable 'show breadcrumbs' and then click into the code Preferences - Code Editor - Display Also make sure you're using a modern version of SQLDev.
1
2
Did you know? SQL Developer Web/Database Actions can take your XML, JSON, or AVRO files and create new relational tables for your @OracleDatabase Read more about this useful feature here - thatjeffsmith.com/archive/20… #oracle #database #converged #json #sql
2
8
Celebrating and recognizing the women on the Oracle Database Tools team - without these rock stars, you wouldn't have things like SQL Developer, SQLcl, ORDS, Database Actions, OCI Database console pages, and much more. #womensday #Oracle linkedin.com/posts/thatjeffs…
6
15
Who's ready for some Tips & Tricks? piped.video/watch?v=8-aUXY2n… See the video description if you want to skip around! #oracle #sqldev #database

Oracle SQL Developer Tips and Tricks: Data Edition

Tips and tricks for turbo charging your Oracle Database experience ...

youtube.com
5
8
Tip: If you need to set a common property from one of your data model's objects, e.g. a table's Primary Key definition, for all or selected tables, use the Propagate button #oracle #database #design #ddl #datamodeling
2
12
Replying to @oraesque
Yes...there are a few options, be sure you're choosing the intended variation.
1
2
Our 10,000th follower is @Mirela_RoOUG !!! Thanks everyone for the last decade of support, and we look forward to our next 10,000! #oracle #database #developers
4
20
Today's #SQLDev Tip: Dealing with your PL/SQL refcursors...in a SQL worksheet or our Procedure Editor @thatjeffsmith shows how here thatjeffsmith.com/archive/20… #oracle #plsql #ide
4
9
Looking for something in your code? Use our Search feature! Code can include - PL/SQL source - PL/Scope metadata - SQL in your VIEWs - the code behind your @OracleREST Web Services Click on search results to open/inspect. #oracle #ide #sql #plsql
5
13
If there is one power feature to know in #oracle #sqldev - it is to take advantage of the Statements panel - how is SQLDev getting this info? - why am I seeing something other than what I expect to see? See what runs, with what :binds, and how long it takes to run #debug
2
14
Tip: You can configure what's included in your @OracleDatabase execution/explain/autotrace plans! #oracle #database #ide #sqldev #sql #optimization
2
14
First tip of 2020! Need help with administrative tasks for your @OracleDatabase? Double the features available to you by opening the DBA panel! Find a quick overview of those features here - speakerdeck.com/thatjeffsmit… #oracle #sqldev #database #admin #dba
1
2
14
Instead of 1 tip for getting the most out of #oracle #sqldev today, how about 10? thatjeffsmith.com/archive/20… Plus 2 bonus tips!
7
19
Today's Tip: A three minute video tutorial on using #SQLDev to refactor your #SQL using either ANSI or #Oracle syntax JOINs piped.video/watch?v=BcM2ksaH…
3
13
Today's Tip: Curious what the squiggle line indicators under your SELECTs and *s mean? #oracle #sql #insight SQL Text Expansion - what is the SQL behind the SQL? * Expansion - what are the columns?
1
2
12
Today's Tip: Code Templates! Program your most frequently used code bits, access them by name in code editors via Ctrl+Spacebar #oracle #sqldev #sql #ide
1
3
34
Oracle LiveLabs - see how to load data using SQL Developer Web for Autonomous @OracleDatabase oracle.com/goto/adw/tutorial See Workshop 1 and Lab 3 #oracle #database #learn
4
10
This week's #FF are for our Oracle User Groups! @POUG_ORG @UKOUG @EastCoastOracle @odtug @apacouc @utoug @RMOUG_ORG @DOAGeV @OUGNorway @aioug @bgoug @it_oug @iloug_org @cougorg @meoracleug @nwoug RT and add those we have missed!
3
4
15
Replying to @itylergarrett @towernter @Lawie7 @sqldaily @SQLShack
We do try to help you...
1
1
Today's tip: Keyboard Shortcuts - Know Them! Or, you can change them to fit your preferences! Here's what you need to know for Windows and OS X #oracle #sqldev #shortcuts
27
91
Load more