Author: Awais Farooq

Oracle DISTINCT clause is used to remove the duplicate records from the result set. It is only used with SELECT statement. Syntax: Parameters: expressions:It specifies the columns that you want to retrieve. tables: It specifies the table from where you want to retrieve records. conditions: It specifies the conditions that must be fulfilled. Oracle DISTINCT Example: (with…

In Oracle, DELETE statement is used to remove or delete a single record or multiple records from a table. Syntax Parameters 1) table_name: It specifies the table which you want to delete. 2) conditions: It specifies the conditions that must met for the records to be deleted. Oracle Delete Example: On one condition This statement will delete…

In Oracle, UPDATE statement is used to update the existing records in a table. You can update a table in 2 ways. Traditional Update table method Syntax: Update Table by selecting rocords from another table Syntax: Parameters: 1) column1, column2, … column_n: It specifies the columns that you want to update. 2) expression1, expression2, …expression_n:…

The Oracle INSERT ALL statement is used to insert multiple rows with a single INSERT statement. You can insert the rows into one table or multiple tables by using only one SQL command. Syntax Parameters 1) table_name: it specifies the table in which you want to insert your records. 2) column1, column2, column_n: this specifies the columns…

In Oracle, INSERT statement is used to add a single record or multiple records into the table. Syntax: (Inserting a single record using the Values keyword): Syntax: (Inserting multiple records using a SELECT statement): Parameters: 1) table: The table to insert the records into. 2) column1, column2, … column_n: The columns in the table to insert…

The Oracle SELECT statement is used to retrieve data from one or more than one tables, object tables, views, object views etc. Syntax Parameters 1) expressions: It specifies the columns or calculations that you want to retrieve. 2) tables:This parameter specifies the tables that you want to retrieve records from. There must be at least one…

You can execute many queries in oracle database such as insert, update, delete, alter table, drop, create and select. 1) Oracle Select Query Oracle select query is used to fetch records from database. For example: 2) Oracle Insert Query Oracle insert query is used to insert records into table. For example: 3) Oracle Update Query…

In Oracle, view is a virtual table that does not physically exist. It is stored in Oracle data dictionary and do not store any data. It can be executed when called. A view is created by a query joining one or more tables. Oracle CREATE VIEW Syntax: Parameters: Example: Let’s take an example to create…

In Oracle, local temporary tables are distinct within modules. These tables are defined and scoped to the session in which you created it. Declare local temporary table Syntax Parameters table_name: The parameter table_name specifies the local temporary table that you want to create. column1, column2,… column_ n: It specifies the column that you want create in the…

Temporary tables generally contain all of the features that ordinary tables have like triggers, join cardinality, information about rows and block etc. the main difference is that the temporary tables can’t have foreign keys related to other tables. Syntax Parameters table_name: The parameter table_name specifies the global temporary table that you want to create. column1, column2,…