Downloading Oracle 12C from web
Step 1: Open the browser and search Oracle 12C for download. Fig 4.1 Step 2: Download the two files as seen on the web. Fig 4.2 Step 3: The two downloaded setups can be seen. Fig 4.3
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 …
Executing queries using UPDATE statements
Executing queries using UPDATE statements The update query is used to update certain records in the table based on a certain condition or expression. We can execute the update statement as in Fig 7.8 Fig 7.8 The above figure executes the update query on the table students where a certain city is updated based on …
Executing queries using DELETE statements
Executing queries using DELETE statements The delete statement is used to delete certain records from the table based on a certain condition or expression. Fig 7.10 shows how to execute the delete statement. Fig 7.10 The fig 7.11 shows how this delete command is executed and the results are shown. Fig 7.11 The above figure …
EXECUTING queries USING DROP statement.
EXECUTING queries USING DROP statement. The drop statement is used to drop a table from a database using the SQL plus query interface. Fig 7.12 shows how this statement is executed to drop a table. Fig 7.12 This shows shows to execute the drop statement and to drop a table from the database. The figure …
Creating a partition using SQL plus
Partitioning involved dividing the table or index into smaller piece .Each of the indivisual pieces act as an independent object which may be having the independent storage characteristics. However from the applications point of view it acts as a non partitioned database only and does not interfere with the DML commands. There are 3 kinds …
Indexing in Oracle 12C
Indexing in Oracle 12C is generally creating an index on a partitioned table, one or more set of columns. The prerequisites for creating an index are:- » One should have a Create index privilege » The indexing needs to be done one the schema owned. » The privilege of the creating index on object should …