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

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

social.ora.cl/6018rRdoj

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

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

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

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

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

@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

Take a few seconds, learn up to 5 new tricks in Oracle SQLDev!

#oracle #sql #database #developer

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.

You can format how your code is decorated in the preferences. For example when you ctrl+click to open objects...

If you liked this tip, our product manager made a video that's dedicated to Data specific tips and tricks

youtube.com/watch?v=8-aUXY…

See the chapters/video description for jump points.

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

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/2022/0…

A quick trick: asked and answered on @StackOverflow

stackoverflow.com/a/71118881/115…

Quickly adding quotes/commas to a list of values for a WHERE IN clause.

#sql #sqldev

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

@FixOnCactus Have you tried at least a dark them for your SQL Worksheet and Code Editors?

draculatheme.com/oracle-sql-dev…

On windows, you can also set your OS to dark mode and SQLDev to WIndows Look & Feel and it will adopt that

Jump straight to the SQL Developer Web Tips and Tricks here
youtu.be/X76H0FMsp-k?t=…

Jump to youtu.be/X76H0FMsp-k?t=… for SQLDev tips!

@DenesKubicek We built a complete interface into SQL Developer Web itself. We recommend you start using that for your dev, doc, and testing.

@PNosko @renenyffenegger @lukaseder 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 :)

@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/…

Using the Command Palette in Database Actions (Ctrl+Shift+P)..a tip via GIF!

#oracle #code #sql #ide #sqldev

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/2014/0…

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

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/or…

#oracle #sql

Friday Tech Tip: Our formatter 'hints' work across ALL of our tools!
SELECT /*csv*/ * from employees;

JSON, INSERTs, HTML, XML, Custom Delimiters...

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

@jnagtzaam @thatjeffsmith @oraclesqlcl 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

@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.

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/2020/0…

#oracle #database #converged #json #sql

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/thatjeff…

Who's ready for some Tips & Tricks?

youtube.com/watch?v=8-aUXY…

See the video description if you want to skip around!

#oracle #sqldev #database

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

@oraesque Yes...there are a few options, be sure you're choosing the intended variation.

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

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/2011/1…

#oracle #plsql #ide

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

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

Tip: You can configure what's included in your @OracleDatabase execution/explain/autotrace plans!

#oracle #database #ide #sqldev #sql #optimization

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/thatjeffsmith/…

#oracle #sqldev #database #admin #dba

Instead of 1 tip for getting the most out of #oracle #sqldev today, how about 10?

thatjeffsmith.com/archive/2020/0…

Plus 2 bonus tips!

Today's Tip: A three minute video tutorial on using #SQLDev to refactor your #SQL using either ANSI or #Oracle syntax JOINs

youtube.com/watch?v=BcM2ks…

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?

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

Oracle LiveLabs - see how to load data using SQL Developer Web for Autonomous @OracleDatabase

oracle.com/goto/adw/tutor…

See Workshop 1 and Lab 3

#oracle #database #learn

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!

@itylergarrett @towernter @Lawie7 @sqldaily @SQLShack We do try to help you...

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

The tips keep on coming! RT if you want more!

When dealing with execution plans - cached, Explains, or even AutoTraces, use the Search feature to find ANYTHING

Object names, notes in the XML portion, etc.

#oracle #sql #fast

@BakhtawarAwan12 Resetting your user's password, video
youtube.com/watch?v=3HcQa-…

This requires you know the current password.

@BakhtawarAwan12 You will need an administrator to unlock your account or reset your password.

If this is a database you have installed or created, you can use the SYSTEM or SYS accounts to do this.

In yesterday's tip we teased object search.

But what if you want to search your code?

REST Services, Views, or PL/SQL - that's all possible.

If you're using PL/Scope, you can use ALL_STATEMENTS - much faster than searching SOURCE for your SQL

Search, click, open = EASY

2 Tips in 1 - Navigating objects in your connection, did you know there was a history, like your browser?

Can't find what you're looking for? Use the Search!

#Oracle #SQLDev #Database

Today's Tip: Did you know you can open a trace (.trc) file, directly in #SQLDev?

#oracle #sql #performance #diagnostics

Tip: Spending a few minutes in the Preferences can go a long way to making #SQLDev a more welcoming environment...for YOU!

#oracle #ide #database

New for version 20.2 - debug your PL/SQL with either JDWP or the classic DBMS_DEBUG interfaces

More on 20.2 updates here
thatjeffsmith.com/archive/tag/20…

#oracle #database #developer #tools

Today's Tip: Your Data Models can get quite large, too large to process easily...visually or otherwise.

The solution? Use SubViews! The 'Select Neighbors' makes this easy to grab groups of related entities or tables.

Read More -
thatjeffsmith.com/archive/2013/0…

#oracle #design

Did you know?

SQL Developer's DBA panel includes an interface to Auditing for your @OracleDatabase!

You can define the settings for, or browse the contents of your Audit trails.

#oracle #dba #security

Get to your Execution Plan as quickly as possible! Did you know we can figure out the SQL_IDs for your queries, automatically?

Quick overview of this feature -
thatjeffsmith.com/archive/2018/0…

#oracle #sql #querytip

Tip: Quickly export your PL/SQL to a SQLcl style script using SPOOL and DDL commands in your SQL Developer SQL Worksheet

#oracle #sqldev #tips #plsql

Maximize your desktop layout efficiency - pin database objects, then drag them around to see more than one thing at a time!

Product manager @thatjeffsmith talks about that in detail here

thatjeffsmith.com/archive/2013/0…

#oracle #ide #sqldev

We have the same code providing support for our SQL scripting features in SQL Developer, SQLcl, and SQL Developer Web (via ORDS)!

That means you can run INFO(+) in SQL Dev Web. However, we do restrict access to the OS, so things like HOST or SPOOL won't be available.

Trick: Multi-Statement Execution to Grids.

Tip: Close those grids when you're done browsing results so as not to leave server resources tied up.

#oracle #sql #sqldev

Did you know?

Insight (Ctrl+Spacebar) can help with INSERT statements!

#oracle #sqldev #ide

We have a new home...page! Thanks @ashleychen5 for making us look so good!

One page, quick links to find SQLDev, SQLcl, SQL Developer Web, and Data Modeler.

oracle.com/database/techn…

New to Oracle? Can't find your tables?

We can help!

In this post, @thatjeffsmith shows how to take advantage of SYNONYMS for easier browsing.

thatjeffsmith.com/archive/2013/0…

#oracle #database #101

3 Things You Show Know about working with PL/SQL In Oracle SQL Developer

Watch and learn in under 7 minutes
youtube.com/watch?v=tnIoIY…

#oracle #sqldev #ide #plsql

Clipboard Tricks
1) Extended Paste - comes in handy when you think you've 'lost' something, and preview before you paste.

2)Drag&Drop numbers or text from a grid to your WHERE IN ( ) clause for properly formatted CSV lists.

#oracle #sqldev

@amyccaldwell No, it was removed a few years ago. Set your formatter preferences as desired, and format on demand.

There IS an option in the formatter to ONLY do the UPPER/lower if that's all you want.

Oracle SQL Developer 101: Navigating your PL/SQL - use the Quick Outline Panel!

thatjeffsmith.com/archive/2012/1…

#oracle #ide #plsql

Asked and answered, how to generate DDL without the partitions in Oracle?

Also works in @oraclesqlcl

#oracle #table #ddl

Need to generate DDL for a user account AND include their security GRANTs?

You're just a click away!

Or, try the Create Like feature that @thatjeffsmith explains here
thatjeffsmith.com/archive/2015/1…

#oracle #database #security

Asked an answered, what does the 'triangle' (it's a rhombus) signify on a Barker Notation ERD

reddit.com/r/oracle/comme…

#sqldev #DataModeling

New video!

30 minutes of data-driven tips and tricks

youtube.com/watch?v=8-aUXY…

#oracle #sqldev #learn

Today's Tip: We can find a SQLID for your SQL statement, and its plans.

This can be much more accurate and useful than a simple Explain Plan

#oracle #sqldev #sql #tune

Trick or Treat!

Or just a trick...

#oracle #sql #refactor #joins #gif

Remember, help with your SQL and PL/SQL is sometimes just a click away...

#sqldev #docs #insight #examples

This week's tip - You can browse/work with as many objects at once, as you'd like.

PIN the document, before you open a 2nd one of the same type.

So before opening your 2nd table, PIN the first one.

You can optionally set your preferences to AUTO-PIN objects.

#oracle #sqldev

Tip: If you're having character display issues, check your FONT

#oracle #sqldev #unicode

If you want the data out, comma-delimited, drag and drop directly out of the grid into a worksheet...

#oracle #sqldev #csv

Did you know? You can copy JUST the column headers from your SELECT * FROM queries...

Select a cell for each column you want the name, then right-click on the header.

#oracle #sqldev

AutoTrace, a GIF story.

#Oracle #Tune #Performance #SQL

3 Minute Quick Tip: Refactoring your Oracle <=> ANSI JOINs

youtube.com/watch?v=BcM2ks…

#oracle #sql #sqldev

What the 'squiggle' lines mean when writing your SQL statements - we're offering to help, or let you know your statement might not be correct.

3 examples -

#oracle #database #sqldev

@demablogia The model tab on a table shows this for one level...

I think to get what you're looking for is to RE the entire schema, then select your table, and use the 'Neighbors' trick to build a new SubView.

thatjeffsmith.com/archive/2013/0…

Tip: Customize the types of objects show in your connection trees.

Preferences - Database - Navigation Filter

#oracle #sqldev #ide

The Welcome/Start page has reminders for new versions, as well as quick starts for connections, help setting up your TNS, and more.

Read all about it here thatjeffsmith.com/archive/2018/0…

Check the #SQLDev family download pages...

Want your table (or column or any type of objects) in your code to be a certain color in the SQL Worksheet and Code Editors?

Inspect your Code Editor, PL/SQL Syntax Colors preferences.

#oracle #ide #sql

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/2014/0…

HT @amyccaldwell

#oracle #ide #docs

Connection Colors, set a visual reminder of where you are before you...forget you're in PROD

#oracle #ide

At the command line with @oraclesqlcl? You can set dynamic prompts which might help as well, examples here thatjeffsmith.com/archive/2016/0…

50,000 views and counting! See in 3 minutes how to format your query results to CSV (or json, xml, insert statements, etc)

youtube.com/watch?v=5pA4Eh…

#oracle #csv

Tip: Drag and Drop 1 or more columns from the connection tree to a SQL Worksheet, have an INSERT for JUST those columns generated

#oracle #sqldev #sql

@AndileJola Short (15 min) version:
youtube.com/watch?v=rnfO8O…

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/2018/0…

A GIF with so many tricks, you'll need to watch this 2 or 3 times to pick them all up!

#oracle #sql #sqldev

Thursday Tip Time!

Want to know how SQL Developer is getting the information you see on screen?

View - Log - Statements
This panel shows everything we execute on the Oracle JDBC driver - includes execution times and the bind variable values!

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