Oracle SQL Developer Tips and Tricks: Data Edition

Tips and tricks for turbo charging your Oracle Database experience when using SQL Developer to work with your data.
TOC
Exporting data 1:40
Grid Tricks 7:30
Object Links and Gauges in your Grids 12:30
Code Insight 16:50
Toggling Oracle to ANSI style JOINS 20:30
Find missing foreign keys 22:30
Exporting multiple tables to a single Excel file 23:00
Plans and tuning 27:10

[@Praveenkumar-vg3pn]

Dear Jeff, it is so cool. we(at least I ) never knew that we can do something as cool as this in SQL Developer.. thank you so much!

[@JeffSmiththat]

Thanks for the feedback, there's even more cool stuff you can do!

[@kevinzhang8974]

I wish I had watched this earlier ... super super useful!!! Thank you Jeff!!!

[@JeffSmiththat]

Hey, I tried to tell you ;) I'm happy you did find the time to watch it, and even better, that it was helpful! Don't forget to give it the thumbs-up so OTHERS can find it too!

[@kevinzhang8974]

@@JeffSmiththat definitely it is a thumbs-up. today I just want the whole video again to refresh.

[@pmpartners]

Thanks for the tips , they will be useful!

[@andybecker5001]

Had no idea you could spool in developer. Neat.

[@JeffSmiththat]

you can spool in SQLcl as well, and with the 'cd' command, you can spool the file to anywhere you want :)

[@rakeshpanigrahi577]

Thanks a lot Jeff :)

[@JeffSmiththat]

You're very welcome!

[@ThePomelo09]

awesome ty

[@JeffSmiththat]

No problem!

[@same95ful]

#Jeff Smith @Jeff Smith , you rocked man :-)

[@rrcr4769]

Hi Jeff, I have installed the Oracle EBS r12.2.10 on an Oracle VM. I able to connect using putty to the VM and login to the database using SQLPLUS. But I am NOT able to connect to the EBSDB using the SQLDeveloper from the host machine. I could connect with out any issues with the R12.2.9 instance backend Sir. How do I over come this issue with the R12.2.10? Thank You. Raj

[@JeffSmiththat]

from your machine to the vm...sqldev needs a network path to get to the database. On my VM's i setup a local port forward to make this easy. Does your VM have an IP address that you can ping from your host?

[@rrcr4769]

@@JeffSmiththat Hi Jeff, Thank You for your response. Yes it does have. I am able to connect to the VM using Putty. I am using only the Host-Only Adaptor so I don't have to port forward.

[@JeffSmiththat]

@@rrcr4769 change your adapter to get an ip address

[@dejankovacevic153]

Is there a way to collapse all procedures within a package using a shortcut? Thank you.

[@JeffSmiththat]

if your focus is on the tree/package item, Left arrow will do that

[@dejankovacevic153]

@@JeffSmiththat No. Inside pkg. Right now ii can do that with + sign but it will be good to have option to colapse all at once.

[@dejankovacevic153]

@@JeffSmiththat Oh now i see, thank you

[@JeffSmiththat]

Here's the post for the grid (links and gauge) tricks www.thatjeffsmith.com/archive/2012/03/sql-developer-query-grid-tricks/

[@ursus9104]

So no need for Toad anymore once you get used to SQL Developer?

[@JeffSmiththat]

I haven't touched it since 2011. So I would say, 'yes', you no longer need it.

[@vinayaksutar7309]

Can someone pls tell, how to use the DDL COMMAND will be really helpful. Timestamps 5:52

[@JeffSmiththat]

just type ddl employees If employees is in your current schema, you'll get the CREATE TABLE EMPLOYEES...sql script. If you want to change how it's generated, see the following command: SET DDL You can use 'help ddl' or 'help set ddl' for the syntax required to use these commands/features.

[@vaibhavpingalkar987]

Peek behind the curtains trick doesn’t work for me, any reason? Thank you for the tricks though

[@JeffSmiththat]

Peek behind the curtains...what trick is this?

[@vaibhavpingalkar987]

@@JeffSmiththat when we click on * (From Select) we can choose columns manually, you have shown in your video, I don’t get little pick under *, Also, CTRl+ space bar also doesn’t work every time

[@JeffSmiththat]

@@vaibhavpingalkar987 sounds like the parser is confused...do you see any red squiggle lines? Make sure there is no invalid sql above or below your sql statement.