Karan Rajpoot Oracle DBA Blog's

                                      Steps to Install Oracle SQL Developer  Step 1) You need to download the SQL developer rpm and java development kit rpm of the version as per your requirement. Links to download rpm's: - Java development kit: -  https://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html SQL developer: -  https://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html Step 2) Login to your Linux Machine and install both the rpm's. [root@dr sf_Oracle_DBA_Softwares]# rpm -ivh sqldeveloper-18.4.0-376.1900.noarch.rpm Preparing...                ########################################### [100%]    1:sqldeveloper           ########################################### [100%] [root@dr sf_Oracle_DBA_Softwares]#  [root@dr sf_Oracle_DBA_Softwares]# rpm -ivh jdk-8u201-linux-x64.rpm warning: jdk-8u201-linux-x64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY Preparing.

                                                          Types of SQL Statements The SQL statement can be categorized into the following four ways: - 1)  DDL ( Data Definition Language) 2) DML ( Data Manipulation language) 3) DCL ( Data Control Language) 4) TCL ( Transaction Control Language)  Now we will understand each of the above statements with examples: - 1) DDL ( Data Definition Language): -  The DDL statement provides commands for defining relation schemas, that is for creating tables, indexes, sequences and so on and also commands for dropping, altering renaming objects. a) CREATE: - It is used to create objects in the database. Example: - Object Creation b) ALTER: - It is used to alter the structure of the database. Example: - Alter the structure of the database c) RENAME: - To rename an object. Example: - Rename of a tablespace d) DROP: - This command is used to delete the objects from the database. Example: - Drop ob