How can I download and set up SQLplus for running SQL commands?

Question

I have just begun learning SQL databases. And I tried my first SQL class where I logged in with my login details and studied introductory content. I got my assignment to create a table and enter values. 

But my SQL plus is giving me an error: "ocl.dll" error

How can I deal with it?

Answer 1

Download the Oracle Instant client from this link in case you want SQL Plus. 

Now make sure that you have SQL Plus exe on your path. 

If you want an alternative, use SQLDeveloper from this link or SQLcl 

Alternatively, you can also use Oracle SQLDeveloper from here or SQLcl. You can prefer SQLcl because you can connect to any Oracle database by using EZconnect syntax

sql.exe usernamepassword@yourdatabasemachinename:yoursqlportnumber/databasename

e.g.,

sql barry/omagh@devbox:1521/DEVDB1

If you want to get more insights into SQL, check out this SQL Course from Intellipaat.