Active3 years, 11 months ago
Instant Client Downloads for Microsoft Windows (x64) 64-bit See the Instant Client Home Page for more information about Instant Client. The installation instructions are at the foot of the page. Oracle Client-to-Oracle Database version interoperability is detailed in Doc ID 207303.1.For example, applications using Oracle Call Interface 19 can connect to Oracle Database 11.2 or later.
I am sorry, for bugging you all with a very silly question probably, but I just started learning data base management system, and today I attempted my first sql class where I had to login by providing my login details and learned some introductory syntax. But I already got my first sql assignment where I have to create a table and enter values. For that I need to downlad sql plus in my computer. I opened the Oracle website and got confused. Didn't understand how to do it,neither could find a good step by step instructions by which I can understand it and download. Please provide a step by step process with links by which I can download it properly. Also I would like to say, my school provided sql plus software but it isn't running and giving an error 'ocl.dll' error. I really need your help. Thanks in advance.
Demietra95Demietra95
2 Answers
If you need SQL*Plus you can download the Oracle Instant client from here
Install this and make sure you have the SQL*Plus exe on your path.
Free Oracle Sql Plus Download For Windows 7
Alternatively you can also use Oracle SQLDeveloper from here or SQLcl which is a java based command line for Oracle SQL based on the SQL engine we built for SQLDeveloper. You can download it here.
SQLcl is very easy and you can connect to any Oracle database using EZconnect syntax
e.g.,
Any questions on these, take a look at the community pages here.
Hope this helps.
B
Barry McGillinBarry McGillin
I felt adding sql server and installing took a lot to discover and understand so I am adding some steps to get the same usage that one can find using sql+ tool. This installation is for oracle 11g express edition. This is the link from which you can download oracle database software
- extract the zip file(dont change the name)
- Start the 'Setup'
- when asked to choose password choose something you will not forget and write it downcause this cant be changed easily later
- When it will be installed completely, you willsee a shortcut in desktop which in most of the cases doesn't work
- Open your browser type this link
caution: this port number can be 8081 or something else with respect to your free ports. If its occupied then when installing a window will appear having a PORT number section,one can see the number there.
6.You will see a oracle window,choose 'ApplicationExpress'
- when you see a prompt of login put SYSTEM as user nameand give the password you have chosen in 4th step
- You will see another window 'Create ApplicationExpress Workspace'
- Choose 'Create New' as 'Database Username'Give a name to 'Database Username' and that must be same with the next 'Application Express Username'
- Password same as 4th
![Oracle Oracle](/uploads/1/2/5/0/125028256/656993976.png)
11.You will see a window again where you have togive your password
- Now you will see 4 optionschoose 'SQL Workshop'->'sql Commands'
- You are all set and you can do everything here.
- Otherwise CLIMAX: Go to search button of your pc type 'Run SQL Command Line'. You will see the Command Line Interface.
- Type in the window after SQL>CONNECT USERNAME/PASSWORD
(these credentials are what you created in 9th and 10th step)Now you are ready to do whatever you want
Demietra95Demietra95