Home 2021 October

Monthly Archives: October 2021

white ruled notebook

LIKE Operator : Pattern-matching Conditions

0
The pattern-matching conditions compare character data. LIKE Condition * The LIKE conditions specify a test involving pattern matching. Whereas the equality operator (=) exactly matches one...
a red xbox game controller and an uno card

Control files in Oracle (Physical Storage)

0
The database control file is a small binary file associated with only one database. Each database has one unique control file, although multiple identical copies...

Flush SQL Statement from Shared Pool

0
If you flush the shared pool, all the statements in cursor will be flushed. Sometimes it is required to flush the bad SQL_PLAN from...
red check mark on box in close up view

Overview of Checkpoints !!

0
A checkpoint is a crucial mechanism in consistent database shutdowns, instance recovery, and Oracle Database operation generally. The term has the following related meanings: • A...