Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Truncate Table
Published by :
Obay Salah , December 1, 2024
In Oracle, TRUNCATE TABLE statement is used to remove all records from a table. It works same as DELETE statement but without specifying a WHERE claus... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Delete Statement
Published by :
Obay Salah , December 1, 2024
In Oracle, DELETE statement is used to remove or delete a single record or multiple records from a table.SyntaxDELETE FROM table_name &... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Update Statement
Published by :
Obay Salah , December 1, 2024
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 methodSyntax:... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Insert ALL statement
Published by :
Obay Salah , December 1, 2024
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 tab... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Insert Statement
Published by :
Obay Salah , December 1, 2024
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 keyw... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
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