Tech Articles PL SQLIn this section we will be testing the Oracle Installation, Connecting to Database and creating an user to start learning Oracle. Please download SQL*Plus Getting Started for Windows tutorial from link below. This tutorial covers the following topics which are very important that you learn and understand. This is very good tutorial from Oracle which covers basic concepts of SQL * Plus, Installing SQL*Plus Help and Demonstration Tables(Optional), Using SQL*Plus,Using the Command Line Interface and Using the Graphical User Interface.
Connect to Oracle using SQL*Plus
Enter Username : system, Password: manager and leave the host string blank since it's the local Database . We will learn the need of host string later.
Now we will be creating an user and grant DBA permissions which we will be using for our practice.
Step 1:
Sytax: CREATE USER 'username' IDENTIFIED BY 'password';
Replace username and password with any name and password you prefer.
Example:
SQL> CREATE USER EXFORSYS IDENTIFIED BY EXFORSYS;
User created.
Step 2: Since it's the test database, we will be granting permission as DBA.
Syntax: GRANT DBA TO 'username';
Sample:
SQL> GRANT DBA TO EXFORSYS;
Grant succeeded.
Step 3: Now we will be connecting to the Database using the ID and password we created.
Syntax: CONNECT 'username'/'passowrd';
Sample:
SQL> CONNECT EXFORSYS/EXFORSYS;
Connected.
SQL>
Please note that Installing SQL*Plus Help and Demonstration Tables is optional. Here are the chapter you can read from this.
