Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


What is the purpose of osql.exe

Posted on 2009-04-23
Medium Priority
Last Modified: 2013-11-11

     What is the purpose of osql.exe? I thought it was just a tool that an admin would use to access an Oracle instance data. I am trying to figure out if osql.exe is needed on a system where no user interaction is performed on the database(no development). Is it needed when a user fills out a form and the data from that form is sent to the Oracle db using the osql.exe functions?

Thanks! MissyMadi
Question by:missymadi
  • 2
LVL 74

Expert Comment

ID: 24221645
where are you seeing osql.exe?

I'm familiar with it as a sql server tool, but have not used it for Oracle.  Are you sure it is an oracle tool?  what is the path for it?

Author Comment

ID: 24224479
I believe it's Microsofts tool but I use it to access an Oracle 10g db.
I use osql.exe tool to access an Oracle (actually 3) instances. For example, to log onto one of the db's at the DOS command prompt I enter C:\set ORACLE_SID=test         then enter sqlplus. Next I get flagged for a username and password where I log in and get to SQL>
Then I start entering whatever commands I need to (select, drop etc)  to the Oracle data base. If I use the GUI to access the instances I  use Enterprise Manager.

My question is, if no one is manually editing on the back end of the database (entering Select statments etc) does the osql.exe tool need to be present? Would osql.exe need to be present on a system where a user enters data on a GUI ( like a form) where when they hit the save button the data gets saved to an Oracle db?
LVL 74

Accepted Solution

sdstuber earned 500 total points
ID: 24224659
there's no reason to have osql.exe for oracle itself. maybe if you have other microsoft products that have some dependency but oracle won't need it.

I would use sqlplus, not osql

I'm not sure how your example illustrates your use of osql.exe
your example sounds like you are using sqlplus.exe

has someone renamed sqlplus.exe to osql.exe?  maybe it's that simple.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Let’s face it: one of the reasons your organization chose a SaaS solution (whether Microsoft Dynamics 365, Netsuite or SAP) is that it is subscription-based. The upkeep is done. Or so you think.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question