Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Transaction in Oracle Database
Published by :
Obay Salah , November 19, 2024
In both Flashback Table and Flashback versions, Undo Data is used for retrieve objects.Flashback Transaction retrieves all Undo Data F... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Versions Query in Oracle Database
Published by :
Obay Salah , November 19, 2024
Sometimes, as a database administrator, you may need to monitor some modifications to the fields. You need to know the values that a specific... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Table in Oracle Database
Published by :
Obay Salah , November 19, 2024
It is also called Flashback Table Query and this type was introduced in Oracle 10g and is based mainly on the Undo Tablespace,which is returning the t... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Flashback Query in Oracle Database
Published by :
Obay Salah , November 19, 2024
This type has been available since the Oracle9i release, so that we can use it to query the database not for the data that currently exists, but for d... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Undo Management in Oracle Database
Published by :
Obay Salah , November 19, 2024
Have you ever thought about the ROLLBACK process? And have you asked yourself how you can undo the modifications that occurred in some fields? E... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Materialized Views
Published by :
Obay Salah , November 19, 2024
When we discussed Database Link, we learned how to link one database to another and how to access objects in another database.However, you may s... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Database Link
Published by :
Obay Salah , November 19, 2024
In a single database, users can grant permissions to objects they own to other users. However, if you have more than one database, it is impossi... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Oracle Clients Side
Published by :
Obay Salah , November 19, 2024
In order for the Client to connect to the Database Server, it needs to know some information necessary for the success of the connection process... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
External Procedures
Published by :
Obay Salah , November 19, 2024
It is necessary to prepare the listener to be able to accept and complete the call of external procedures. By preparing the listener, you can ca... Continue Reading
Obay Salah Profile
Obay Salah
obay@gmail.com
Oracle OCP
Control Database Access
Published by :
Obay Salah , November 19, 2024
Originally, the listener does not set any limits on connecting to the database and serves all requests, while security and blocking are done thr... Continue Reading