data structure that allows you to access rows in a result set. It acts as a pointer to a specific row in a query result set
What is a cursor?
This operator searches for a pattern of letters
What is like?
PL/SQL program unit that responds to specific events in a database table
What is a trigger?
encapsulated collections of related procedures, functions, variables, and data types
What are packages?
They allow you to group related functionality together and call it from different parts of your application
What are procedures?
It involves dividing a large table into smaller, related tables and ensuring that each table follows specific rules (normal forms) to eliminate data anomalies
What is normalization?
keyword, which selects records that have matching values in both tables.
What is INNER JOIN?
custom exceptions defined by the developer to handle specific scenarios
What are User-Defined Exceptions?