Oracle SQL Developer, 5+ million users strong and growing. Tips, tricks, & news #sqldev
Redwood Shores, CA
- Tweets 2,541
- Following 210
- Followers 14,502
- Likes 478
Installing #Oracle #SQL #Developer is now as easy as searching for 'sql-developer' in VS Code.
social.ora.cl/6018rRdoj
7
59
164
29,009
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
138
11,743
Happy Holidays from the Database Tools team!
As an early present, please find versions 19.4 of SQL Developer, ORDS, SQLcl, & Data Modeler available for download.
@OracleREST 19.4 now also includes SQL Developer Web!
3
35
104
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
28
91
18.2 is now available for you to download. oracle.com/technetwork/devel…
ORDS, SQLcl, and Data Modeler too.
3
55
79
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
76
16,995
Looking to visualize dependencies for your @OracleDatabase objects? Try our open source extension here: github.com/oracle/oracle-db-…
1
50
72
Our @OracleSQLDev extension for @code has a new update available, version 23.4.1!
social.ora.cl/6013ncUrz
Many of the bug fixes are based on your feedback, thanks and enjoy!
3
16
69
5,818
We can't wait for Summer 2023 to get here!
I’m SO excited to announce I’ve been invited to return back to @oracle next Summer 2023!!!
I can’t even put to words how excited I am!! To have the opportunity to return back to my amazing team, the Database Tools team, is just incredible 🥰🥰 IM SO HAPPY
3
2
58
Oracle Database Cloud Services customers (OCI-C), check your updates from this weekend. SQL Developer Web is now available!
3
23
49
Version 18.3 of SQL Developer and also Data Modeler are available for download.
Improvements include:
+ Offline RTSM HTML reports
+ Connection Folders
+ Cart to Cloud
+ Many, many bug fixes
Catch up on 18.x new features here oracle.com/technetwork/devel…
5
25
51
Have slow or problematic SQL in your @OracleDatabase ? We have just the video for you!
social.ora.cl/6018ysz4g
Why and WHERE is the query slow? Our product manager takes you on a tour and shows you how to answer these questions!
#oracle #database #sql #100DaysofCode
19
45
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
In this 15 min video, we show you everything you need to know about SQL execution plans in SQL Developer piped.video/watch?v=-IWxdI9-… #oracle #query #tune
23
48
show connection
show java
show jdbc
Useful for seeing what's what with your current SQL Developer or @oraclesqlcl instance.
#oracle #tools
18
45
A collection of Oracle SQL Developer Videos, 24 and counting! 3 minute quick bites to hour plus long sessions, get your fill here! #Oracle #Learn #SQLDev piped.video/playlist?list=PL…
16
40
Sometimes a human needs to process data via {json} - in which case, the json-formatted output in v19.1 of SQL Developer and @oraclesqlcl might help!
#oracle #data #sqldev #json
2
17
39
SQL Developer Data Modeler v18.1 is now available! oracle.com/technetwork/devel… #Oracle #Database #Design
2
19
35
One of @thatjeffsmith's tips and tricks from @oracleopenworld
this week:
Take a few minutes to set your Data Export options to what you use most frequently - save yourself a TON of clicks.
1
14
38
TNSNames problems aren't always fun to debug. The SHOW TNS command might help! SQLDev and SQLcl.
1
16
35
Hello to all 5,000,000 and counting active users out there! The #SQLDev family continues to grow and we appreciate every single one of you.
1
9
36
50,000 views and counting! See in 3 minutes how to format your query results to CSV (or json, xml, insert statements, etc)
piped.video/watch?v=5pA4EhFY…
#oracle #csv
1
17
34
Check out the new Database Dev Virtual Image. Updates include: SQLDev 4.1.5, ORDS 3.0.9, APEX 5.1 oracle.com/technetwork/datab… #sqldev#ords#apex
2
25
33
Search the Oracle Docs code examples, directly from your SQL Worksheet!
Product manager @thatjeffsmith teaches you how in this quick 2 minute read
thatjeffsmith.com/archive/20…
HT @amyccaldwell
#oracle #ide #docs
3
14
33
Did you know we built a database dependency visualizer into #SQLDev, and open sourced it? github.com/oracle/oracle-db-…
19
34
The DBA Security panel isn't just for managing users and roles - you can also configure auditing and view trails thatjeffsmith.com/archive/20… #Oracle #Security #SQLDev
1
7
30
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
Our team will largely be on holiday until the new year - we hope you have enjoyed 2017 and will enjoy our latest offering!
Last but not least. @OracleSQLDev 17.4 is out.
What is the best color database ?
oracle.com/technetwork/devel…
2
8
27
Just added @SQLMaria's video on how to connect SQL Developer to our new Autonomous Transaction Processing Cloud Service to our SQLDev Playlist. 31 videos and counting!
piped.video/watch?v=RGPTMEPh…
12
27
See how our parser 'sees' your #SQL, use the Code Outline. Also links to syntax diagrams in DOCS
1
15
27
Big thanks for our 4.5+ million users world wide as we roll out version 17.2 this week! Your feedback & constant interaction are priceless.
13
28
This thread is everything you need to know about easy SQL in your browser with @OracleDatabase .. FREE CLOUD!
Did you know you can create and run SQL queries in your web browser? :) it only takes 6 steps to set up!
@Oracle has a free web version of their Oracle Database, that includes a web version of SQL Developer. Take a look ⤵️
1
4
29
New video!
30 minutes of data-driven tips and tricks
piped.video/watch?v=8-aUXY2n…
#oracle #sqldev #learn
13
30
wouldn't it be cool if you could hand-format code and ask SQLDev to set your formatter preferences based on your code sample?
11
4
25
If you missed our webinar this week, here's the recording. Overview &feature tour of your @OracleDatabase IDE &GUI piped.video/watch?v=EguMf4Hb…
11
28
Tip: Spent a few minutes creating some SQL Editor Templates.
Then reuse those going forward. This is key to saving time in your editors, & avoiding mistakes in your code.
#oracle #sqldev #ide
@thatjeffsmith shows how to use this with DBMS_XPLAN here thatjeffsmith.com/archive/20…
10
29
"Oracle has done a fantastic job of providing developer-friendly tools. SQL Developer is a top-notch product that is completely free for developers. It allows people to easily and clearly query and update data… great for in-house development."
Relational Database Top Rated winners announced. Winners are @awscloud, @Microsoft, @Oracle, and @OracleSQLDev. trustradius.com/buyer-blog/2…
1
16
26
Did you know? You can generate HTML Schema docs for your Oracle Database, for free with SQLDev.
11
28
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
7
28
We prefer tricks! Here's one you can all enjoy:
"split" an editor to see more than one element of said document at a time. Here's a Table:
1
9
28
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
A quick look at what you can do with our new extension for @code !
social.ora.cl/6013VG7Uz
1
8
27
6,024
show - jdbc, java, connection. Let SQLDev and @oraclesqlcl SHOW you what's going on with your environment and database connections. #oracle #tools
11
24
Indeed! SQL Developer, SQL Developer Data Modeler, SQLcl, and ORDS versions 18.1 are now available for download!
27
25
2018 - New Features in Review
piped.video/watch?v=hUC0spke…
Skip to 5:35 into the video for 'the good stuff.'
#oracle #sqldev
1
12
24
We are your one-stop-dev shop for installing & running @OracleREST - plus dev/debug/deploy RESTful Services. #Oracle #REST #IDE
13
25
Search feature in @OracleSQLDev version 17.3 now covers your VIEW definitions as well. And don't forget about PL/Scope.
1
8
19
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
DBTools News -
Version 20.1 won't be released.
We're excited to get versions 20.2 for all our tools ready for you, Early Summer 2020!
Oracle SQL Developer for the DBA slides now available
thatjeffsmith.com/archive/20…
Here you go @rtpelegrino - you made me blog on a Saturday ;)
#oracle #sqldev #dba
10
25
