Tag Archives: Oracle

Starting With Oracle SQL

Here in this post I am going to show you how to connect and start SQL using your command prompt. Actually you can use Run SQL Command Line from start menu but problem is that it do not support copy and paste commands which are generally required by most of the developers like you and me. So let’s see how to connect to SQL database using command prompt.

But of-course for doing this you will need Oracle SQL to be installed on your PC. If you are not having it, you can download from the following link.

Download Oracle SQL Express Edition 11g

Oracle SQL is a free to use software but while downloading you might need to login to your Oracle account. If  you are not having an Oracle account, then you can create it for free using sign up option.

The download is nearly 350MB in size. Once downloaded you need to extract to content of zipped file and then launch setup.exe. The setup options are quite similar to other setups. So you are familiar with them or else you can simply go on clicking Next Next ….

While setting it up, you might come across a screen shown below.

On this screen you are suppose to enter password for SYS and SYSTEM user. In oracle database this two are the users with administrative privilege. If you are going to use this installation for development purpose then you can choose ‘admin’ as password. Because admin is very simple to remember and also very simple to enter. You can use your own password also. Once you have chosen password click on next.

As soon as you click on next, the setup will begin to install Oracle SQL on your PC. Wait until setup complete.

Continue reading Starting With Oracle SQL