SQL

Oracle Select Statement

Published by : Obay Salah , December 1, 2024

The Oracle SELECT statement is used to retrieve data from one or more than one tables, object tables, views, object views etc.SyntaxSELECT expres... Continue Reading

SQL

Oracle View

Published by : Obay Salah , December 1, 2024

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 execute... Continue Reading

SQL

Oracle Local Temporary tables

Published by : Obay Salah , November 28, 2024

In Oracle, local temporary tables are distinct within modules. These tables are defined and scoped to the session in which you created it.Declare loca... Continue Reading

SQL

Oracle Global Temporary tables

Published by : Obay Salah , November 28, 2024

Temporary tables generally contain all of the features that ordinary tables have like triggers, join cardinality, information about rows and block etc... Continue Reading

SQL

Drop Oracle Table

Published by : Obay Salah , November 28, 2024

Oracle DROP TABLE statement is used to remove or delete a table from the Oracle database.Syntax:DROP [schema_name].TABLE table_name &nb... Continue Reading

SQL

Alter Oracle Table

Published by : Obay Salah , November 28, 2024

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... Continue Reading

SQL

Create Oracle Table AS Statement

Published by : Obay Salah , November 26, 2024

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... Continue Reading

SQL

Create Oracle Table

Published by : Obay Salah , November 26, 2024

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... Continue Reading

SQL

Oracle Table

Published by : Obay Salah , November 19, 2024

 Database tables are used to store data in the form of some structures (fields and records). Here, a field is a column that specifies the type of... Continue Reading

SQL

Table in Oracle Dtabase

Published by : Obay Salah , November 19, 2024

Database tables are structures used to store data in the form of fields (columns) and records (rows).Fields (Columns): Define the type of data to be s... Continue Reading