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.

Thanks for the tips , they will be useful!

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!

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 :)

Thanks a lot Jeff :)

@JeffSmiththat

Жыл бұрын

You're very welcome!

awesome ty

@JeffSmiththat

Жыл бұрын

No problem!

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

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

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.

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.

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

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.

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