How to download and setup sqlplus for running sql commands?
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.
Answer
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