Oracle12c Tutorial
Installing the setup for Oracle 12C
Step1: As soon as we double click on the set up a pop up comes up . Click Yes in the User Account Control window to continue with the installation. Fig 4.8 Step 2: The Configure Security Updates window appears. Please enter your email address and the Oracle Support password if one wish to receive the security …
Verifying the installation of Oracle 12C
Step1: As soon as we double click on the set up a pop up comes up . Click Yes in the User Account Control window to continue with the installation. Fig 4.8 Step 2: The Configure Security Updates window appears. Please enter your email address and the Oracle Support password if one wish to receive the security …
Verifying the installation of Oracle 12C
In this one has to verify the installation of Oracle 12C by means of certain files and performing certain steps as follows:- Verifying the Oracle services In this we need to navigate to C:\Windows\system32 and double click on the services where you can see the whole list of services as shown in Fig 4.20 Fig …
Oracle environments for Linux /Unix and Window users
There are some differences which exist between the Oracle installation for UNIX/LINUX and the Windows environment. These are as follows:- LINUX/UNIX In this environment one typically creates his own user to own the installation files. This user is called Oracle. Moreover there are 2 OS groups. oinstall This is basically the user’s primary group. The …
Oracle environments for Linux /Unix and Window users Read More »
Setting of environment variables during Oracle installation.
The environment variables play a very important role to determine certain important things like:- • OS where the software has to run • Where will the Oracle will store the files. • Which database will the Oracle connect to. Some of the environment variables are as follows:- ORACLE_BASE This is the top most directory where …
Setting of environment variables during Oracle installation. Read More »
Methods of creating Oracle databases.
One can create a database using various methods out of which 4 are listed as below:- Manually using SQL commands It is recommended that if one is working on a previous release like Oracle 8i then one should use this method as then the DBCA was not as effective. However if the version Oracle 9i …
Creation of Oracle database using the DBCAO.
One can easily create a database using a DBCA as it provides the following advantages:- It provides the necessary templates for defining and configuring a database which the other methods might not provide. Customization can be a lot easier to do and manage using a DBCA. One need not install the features that we are …
Controlling database post creation in Oracle 12C
Controlling database post creation in Oracle 12C It is extremely necessary to do a post checkup after the database has been created. There are 3 things which need to be done:- Checking the initialization parameters that were set during the setup of the database. Performing a backup for the database so that if in future …
Controlling database post creation in Oracle 12C Read More »
SQL calling environments.
SQL calling environments. The first step to learn and execute the SQL command is to understand the following commands in SQL:- Data Manipulation Language (DML) These statements are used to manage the data within the various schema objects. Data Definition Language (DDL) These statements are used to create ,insert or alter structures in the existing and the …
SQL plus as an interface to Oracle.
SQL plus is an interactive query tool which comes in collaboration and installed with Oracle 12C database. It is a client and acts as a interface to access the Oracle database. The advantages of using SQL plus are as follows:- It can be launched directly from the command line interface so no need of accessing …
Beginning of SQL plus with Oracle1 2C
Some of the starting SQL commands are:- Some of the starting SQL commands are:- 1)Startup This command is used to restart /reboot the database or instance. This is necessary to start the database. Please refer to Fig 6.2 and 6.3 2)Shutdown This command is used to shut down the database or to stop the running instance. It …
Executing CREATE statements in SQL plus
Executing CREATE statements in SQL plus We can execute the create table in an Oracle database in which we have to specify the columns that need to be created along with the datatypes for various columns like whether it is a Varchar ,integer or Float kind of an attribute. One needs to use the below …
Executing INSERT statements in SQL plus Executing queries using SQL plus on Oracle database
Executing INSERT statements in SQL plus The insert statement is used to insert data in the Oracle database through the SQL INSERT command. Fig 7.2 The above figure shows the INSERT command being executed where the table is specified along with the values to be inserted in the table. Here in the table Students the values inserted …
Executing the select queries in SQL plus
The select queries is used to fetch the data from the database .We can also use FROM to fetch the data from the table based on certain selection or condition. The below figure shows how to execute the select command. Fig 7.4 Fig 7.5 SELECT USING FROM The below figure shows that the query to …