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 download SQL plus onto my computer. I opened the Oracle website and got confused. Didn't understand how to do it. Neither could I find a good step-by-step set of instructions that I can understand and follow. Please provide a step-by-step process with links through which I can download it properly. Also, I would like to say that my school provided SQL plus software, but it isn't running and is throwing an error ocl.dll error. I really need your help.
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.
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
sql.exe usernamepassword@yourdatabasemachinename:yoursqlportnumber/databasename
e.g.,
sql barry/omagh@devbox:1521/DEVDB1
Any questions on these, take a look at the community pages here.
Hope this helps.
B