Data Consistency
Data Consistency In Oracle Database, each user must see a consistent view of the data,…
Read more2022
Introduction to Oracle SQL
Structured Query Language (SQL) is the set of statements with which all programs and usersaccess…
Read moreSample Schemas
In Oracle Database, a database schema is a collection of logical data structures, or schema…
Read moreDatafiles in Oracle (Physical Storage)
Overview of Data Files At the operating system level, Oracle Database stores database data in…
Read moreOracle Database 19c – Practical & Assignments
PARAMETER & PASSWORDFILE: * Create pfile from spfile to location '/home/oracle/init<sid.ora>' * Create password file…
Read moreSystem Change Numbers (SCNs)
A system change number (SCN) is a logical, internal time stamp used by Oracle Database.…
Read more