Category: Oracle

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,…

In Oracle, ALTER TABLE statement specifies how to add, modify, drop or delete columns in a table. It is also used to rename a table. How to add column in a table Syntax: Example: Consider that already existing table customers. Now, add a new column customer_age into the table customers. Now, a new column “customer_age”…

The CREATE TABLE AS statement is used to create a table from an existing table by copying the columns of existing table. Note: If you create the table in this way, the new table will contain records from the existing table. Syntax: Create Table Example: copying all columns of another table In this example, we…

In Oracle, CREATE TABLE statement is used to create a new table in the database. To create a table, you have to name that table and define its columns and datatype for each column. Syntax: Parameters used in syntax Oracle CREATE TABLE Example Here we are creating a table named customers. This table doesn’t have…

Oracle database is a relational database management system (RDBMS) from Oracle Corporation. This article will explain a complete overview of the Oracle database, features, history, and editions. Before discussing the oracle, we will first need to know about the database. What is a database? A database refers to the organized collection of structured data stored electronically in…

Oracle tutorial provides basic and advanced concepts of Oracle. Our Oracle tutorial is designed for beginners and professionals. Oracle is a relational database management system. It is widely used in enterprise applications. Our Oracle tutorial includes all topics of Oracle database such as insert record, update record, delete record, select record, create table, drop table…