The 12th class computer science students have SQL in their syllabus. They also have it for the Plus Two practical exams which makes it very important. The lab sessions available in school time is not enough. So you have to install it in your computer. The schools have Windows XP installed in them. The version they use probably be an old version. Even if you try to get the software from school, it is going to be useless. Because, today most of the computers uses Windows 7 or 8. If you already searched the Internet for SQL Plus, you wouldn't have found anything yet. The reason is there is no standalone software named SQL Plus. The SQL Plus is the SQL Command Line for Oracle Database Software. The software you are looking is Oracle Database. The newest version works in Windows 7, but not sure about Windows 8. It also contains the SQL Command Line which can be used as you do in school.
The version you require is the Oracle Database 11g Express Edition. The file you download will be a RAR archive of 320 MB file size. After you download the file, extract the file and install Oracle Database in your computer. During the installation process, it will ask you to enter password for "system" user. Enter the password and re-enter it in the below field. Keep the password simple and under 8 characters. You should write down the password somewhere, because you need it to use SQL Command Line. Now you can click "Next" and continue the installation. The installation of Oracle Database does not create a desktop for SQL Plus. But it makes a shortcut "Get Started With Oracle Database 11g Express Edition". You can delete this if you like, it doesn't matter. The real thing we need is in the Start Menu. Click on Start and you will see "Run SQL Command Line". Drag it to the Desktop to create a shortcut. If you tried running it, you will see that nothing works! Guys, I'm not done yet!
For the SQL queries to work in SQL Command Line, first you have to connect it to the database. For that type "connect" in SQL Command Line and press enter. Now you will see "Enter user-name:". Type "system" and press enter. Now it will ask for password. You have to type the password you set when you installed it. The characters you type will not be shown. So, you don't have to worry about it and just type the password and press enter. You will see the message "connected.". This means you have installed it correctly and it works fine. You will have to connect and type in your user name and password every time you run SQL Command Line. The connecting process can be skipped using a simple trick:
- Click here to Download Oracle Database Express Edition 11g
- Click on "Accept License Agreement".
- Download the right version for your Windows.
The version you require is the Oracle Database 11g Express Edition. The file you download will be a RAR archive of 320 MB file size. After you download the file, extract the file and install Oracle Database in your computer. During the installation process, it will ask you to enter password for "system" user. Enter the password and re-enter it in the below field. Keep the password simple and under 8 characters. You should write down the password somewhere, because you need it to use SQL Command Line. Now you can click "Next" and continue the installation. The installation of Oracle Database does not create a desktop for SQL Plus. But it makes a shortcut "Get Started With Oracle Database 11g Express Edition". You can delete this if you like, it doesn't matter. The real thing we need is in the Start Menu. Click on Start and you will see "Run SQL Command Line". Drag it to the Desktop to create a shortcut. If you tried running it, you will see that nothing works! Guys, I'm not done yet!
For the SQL queries to work in SQL Command Line, first you have to connect it to the database. For that type "connect" in SQL Command Line and press enter. Now you will see "Enter user-name:". Type "system" and press enter. Now it will ask for password. You have to type the password you set when you installed it. The characters you type will not be shown. So, you don't have to worry about it and just type the password and press enter. You will see the message "connected.". This means you have installed it correctly and it works fine. You will have to connect and type in your user name and password every time you run SQL Command Line. The connecting process can be skipped using a simple trick:
- Right click on the shortcut "Run SQL Command Line"
- Click on properties
- Go to Shortcut tab, maybe you will be already in this tab.
- You will see the target, it is "C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe /nolog". Change it to "C:\oraclexe\app\oracle\product\11.2.0\server\bin\sqlplus.exe"
- Click on "Apply".
- Click on "Continue" in the dialog box now opens.
Comments
Post a Comment