Monthly Archives: February 2022
Data Consistency
Data Consistency
In Oracle Database, each user must see a consistent view of the data, including visible changes made by a user's own transactions and...
Introduction to Oracle SQL
Structured Query Language (SQL) is the set of statements with which all programs and usersaccess data in an Oracle Database. Application programs and Oracle...
Sample Schemas
In Oracle Database, a database schema is a collection of logical data structures, or schema objects. A database user owns a database schema, which...
Protected: Oracle Database 19c – Practical & Assignments
PARAMETER & PASSWORDFILE:
* Create pfile from spfile to location '/home/oracle/init<sid.ora>'
* Create password file with sys password as oracle1
* Create parameterfile in different location /u01...