Oracle SQL Developer Tips and Tricks: Data Edition

Подписаться 9 тыс.

Просмотров 19 тыс.

50% 1

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

Наука

Опубликовано:

24 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 33

@kevinzhang8974 3 года назад

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

@JeffSmiththat 3 года назад

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 3 года назад

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

@pmpartners 4 года назад

Thanks for the tips , they will be useful!

@Praveenkumar-vg3pn 4 года назад

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 4 года назад

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

@andybecker5001 2 года назад

Had no idea you could spool in developer. Neat.

@JeffSmiththat 2 года назад

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

@rakeshpanigrahi577 2 года назад

Thanks a lot Jeff :)

@JeffSmiththat Год назад

You're very welcome!

@ThePomelo09 Год назад

awesome ty

@JeffSmiththat Год назад

No problem!

@rrcr4769 3 года назад

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 3 года назад

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 3 года назад

@@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 3 года назад

@@rrcr4769 change your adapter to get an ip address

@dejankovacevic153 4 года назад

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

@JeffSmiththat 4 года назад

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

@dejankovacevic153 4 года назад

@@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 4 года назад

@@JeffSmiththat Oh now i see, thank you

@ursus9104 2 года назад

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

@JeffSmiththat 2 года назад

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

@vaibhavpingalkar987 3 года назад

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

@JeffSmiththat 3 года назад

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

@vaibhavpingalkar987 3 года назад

@@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 3 года назад

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

@same95ful 4 года назад

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

@vinayaksutar7309 2 года назад

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

@JeffSmiththat 2 года назад

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.

@JeffSmiththat 4 года назад

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