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!
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
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?
@@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 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
@@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.
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.
I wish I had watched this earlier ... super super useful!!! Thank you Jeff!!!
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!
@@JeffSmiththat definitely it is a thumbs-up. today I just want the whole video again to refresh.
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!
Thanks for the feedback, there's even more cool stuff you can do!
Had no idea you could spool in developer. Neat.
you can spool in SQLcl as well, and with the 'cd' command, you can spool the file to anywhere you want :)
Thanks for the tips , they will be useful!
Thanks a lot Jeff :)
You're very welcome!
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
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?
@@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.
@@rrcr4769 change your adapter to get an ip address
#Jeff Smith @Jeff Smith , you rocked man :-)
awesome ty
No problem!
So no need for Toad anymore once you get used to SQL Developer?
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
Peek behind the curtains...what trick is this?
@@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
@@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.
Here's the post for the grid (links and gauge) tricks
www.thatjeffsmith.com/archive/2012/03/sql-developer-query-grid-tricks/
Is there a way to collapse all procedures within a package using a shortcut? Thank you.
if your focus is on the tree/package item, Left arrow will do that
@@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.
@@JeffSmiththat Oh now i see, thank you
Can someone pls tell, how to use the DDL COMMAND will be really helpful. Timestamps 5:52
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.