Direct Connection through Pl-SQL developer

[prasath n]

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.

 

[hadfieldjohn]

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.

 

[Marco Kalter]

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

You can use the EZCONNECT naming method (host[ort][/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.

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

Yes, no problem.