Skip to Main Content
  • Questions
  • Oracle SQL developer's native package???

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Allan.

Asked: February 01, 2018 - 5:30 pm UTC

Last updated: February 02, 2018 - 12:41 am UTC

Version: Oracle SQL Developer Version 3.0.04

Viewed 1000+ times

You Asked

hi Tom:

when I check my ODBC connection under Administration tool, I don't not find any Oracle driver. the strange thing is I can still use Oracle SQL developer to connect to Oracle. I assume we always need a Oracle driver to connect to oracle database- does this mean:

1. Driver is not necessarily listed on the administration tool?
2. Does Oracle SQL developer come with some native package to simulate the driver when you don't have a driver? which
can only be used with Oracle SQL developer?

thanks,

and Connor said...

By default, SQL Developer uses the thin jdbc drivers, which come with the product.

If you *do* have a full Oracle client installed, you can use that as well, via Preferences

SQLDEV_TNS_CLIENT


Is this answer out of date? If it is, please let us know via a Comment

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library