Posted By: prasath n Direct Connection through Pl-SQL developer - 10/27/09 05:49 AM
Direct Connection through Pl-SQL developer

1) Is there option in PL-SQL developer to connect to db without having TNS entry, like the one we have in TOAD.

2) Can we connect to Oracle XE through PL-SQL developer?

Thanks for your time.


You can definitely connect to XE - I'm connected now.

As to how exactly, I'm not certain!

I just type a username and password and leave the 'Database' field blank. My Oracle Home is autodetected (as I have a few Oracle homes on this PC) but the dropdown list of databases suggests it's not using the XE home.

[quote]1) Is there option in PL-SQL developer to connect to db without having TNS entry, like the one we have in TOAD.[/quote]
You can use the EZCONNECT naming method (host[:port][/service_name]) if Oracle Net is configured as such, or you can enter an entire connect descriptor (just like in a tnsnames.ora file) in the Database field.

[quote]2) Can we connect to Oracle XE through PL-SQL developer?[/quote]
Yes, no problem.
© Allround Automations forums