Print Thread
Direct Connection through Pl-SQL developer
#36254 10/27/09 05:49 AM
Joined: Sep 2009
Posts: 3
P
Member
OP Offline
Member
P
Joined: Sep 2009
Posts: 3
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.



Re: Direct Connection through Pl-SQL developer
prasath n #36258 10/27/09 10:13 AM
Joined: Sep 2003
Posts: 27
Sheffield, Yorkshire, England
H
Member
Offline
Member
H
Joined: Sep 2003
Posts: 27
Sheffield, Yorkshire, England
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.


Re: Direct Connection through Pl-SQL developer
hadfieldjohn #36268 10/27/09 10:49 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
[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.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.033s Queries: 15 (0.007s) Memory: 2.5017 MB (Peak: 3.0392 MB) Data Comp: Off Server Time: 2024-03-29 01:35:16 UTC
Valid HTML 5 and Valid CSS