Oracle was designed to run with UNIX while SQL was created for the Windows platform. Oracle Can Still Run on Windows, But Opinions vary as to whether there’s really any noticeable performance differences based on the user’s operating system choice. Oct 04, 2018 Run Oracle SQL.PLUS Script from Command Line in Windows Example. To run the SQL script, follow these steps: Open the command prompt by pressing the key Window+R and then type CMD in the Run window and press enter. In the Windows command prompt, change the directory where your SQL script exists, for example, CD F:mysqlscripts and press enter. I'm trying to use sql.plus to control a small Windows command script. Basically, I want to execute some PL/SQL (perhaps select from a view or table or execute a function) which shows me the status of some rows in the database, and then depending upon the state of the rows, perform some Windows.
And also a countless mountain of new elements, which we will enjoy mixing in the long evenings.Of course, as a veteran I am most intrigued by the skin of 3D World. I want to check how many new cat’s outfit options will be introduced for the brand. Super mario download pc.
Apr 19, 2016 Oracle recommends that users download the latest version of their Java Virtual Machine, by clicking here. Please follow the prompts. How do I get Java to run on Windows 10? I am trying to use a website for a job. I am getting these errors. I have the same problem and use BlueJay to compile and run applets in windows 10. Open command prompt as Administrator (Right click on the command prompt and select Run as Administrator ) and restart lsnrctl mouldblal December 15, 2016 at 4:04 pm At the end when i tried to restart the listener, I’ve an error. Apr 20, 2010 7. Re: Running ORACLE on windows. Actually that is the nub of the problem. We are piloting Oracle BI SE1 at the moment and using the local 32 bit DB (for the repository). The source fact tables are large ( and on a remote DB) - 20Gb - and the BI software is just waiting on SQL.Net delays for the bigger queries.
I am trying to use a website for a job. I am getting these errors.
I follow through, downloaded, restarted, went through internet options and made sure everything was enabled. And still it won't work. I also went to java page to check to see if the script is running and it is not.
Active3 years, 10 months ago
I'm trying to use sql*plus to control a small Windows command script.
Basically, I want to execute some PL/SQL (perhaps select from a view or table or execute a function) which shows me the status of some rows in the database, and then depending upon the state of the rows, perform some Windows commands.
My problem is how to get the results back into the command script.
skaffman
353k9191 gold badges748748 silver badges734734 bronze badges
Cade RouxCade Roux
74.8k3737 gold badges157157 silver badges255255 bronze badges
6 Answers
I'd probably write the script (or the conditional, depending on the requirements) from the called
script.sql itself.
For example, the following
script.sql creates a .bat filewindows_commands.bat :
You can then call
script.sql from yet another .bat file like so:
Running Oracle On Windows ServerRené NyffeneggerRené Nyffenegger
27.5k1818 gold badges119119 silver badges192192 bronze badges
This is what I ended up using.
My .cmd script:
Where script.sql:
Cade RouxCade Roux
74.8k3737 gold badges157157 silver badges255255 bronze badges
I would strongly encourage you to not use .bat files. You've got lots of other alternatives: C/C++ or VB, Windows scripting or Powershell, or even free downloads like Perl or Bash.
But here's one example of returning error codes in .bat files:
But please do look at some of the links I gave above. Avoiding .bat files will make it easier for you, and make it easier to maintain in the future.
IMHO ..
paulsm4paulsm4
84.2k1010 gold badges112112 silver badges138138 bronze badges
I do something like this by creating a .bat file which does the windows stuff and calling sql scripts as needed. Use SQL to spool your results to a text file which you can read.
..dos commands here
Oracle Database Running On Windows
sqlplus /nolog @C:DumpDropRecreateUsers.sql
sqlplus /nolog @C:DumpCleanup.sql
..dos commands
In the sql use this command spool C:yourResults.txt or for more sophisticated usages create a procedure, which, when called, writes the results to a text file using UTL_FILE
kevinskykevinsky
![]()
3,83211 gold badge1717 silver badges3131 bronze badges
I encourage you to take a look at the two scripts included in the Oracle XE for backup and restore. These scripts have taught me a lot how to handle batch-scripting and Oracle on the Windows platform.
Running Oracle On Windows 7
Bjarte BrandtBjarte Brandt
Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options I forgot my windows server 2003 administrator password.
Bartłomiej Semańczyk
36.8k2929 gold badges177177 silver badges266266 bronze badges
Rizwan BasheerRizwan Basheer
Not the answer you're looking for? Browse other questions tagged windowsoraclebatch-fileoracle10gsqlplus or ask your own question.Comments are closed.
|