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

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

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


We're not taking comments currently, so please try again later if you want to add 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