Oracle Notes

Logical backup is used to read a set of database records and writing them into a file. An Export utility is used to take the backup while an Import utility is used to recover from the backup. A logical backup in Oracle refers to the process of backing up the database using a logical method, … Read more

The post-database commit trigger is executed after Oracle forms issue the commit to finalized transaction while, the post-form commit is fired during the post and commit transactions process, after the database commit occurs. In Oracle Forms, “post-database commit” and “post-form commit” are events that occur during the data commit process, but they have different scopes … Read more

Save Points are used to divide a transaction into smaller phases. It enables rolling back part of a transaction. There are maximum 5 save points allowed in Oracle Database. Whenever an error is encountered, it is possible to rollback from the point where the SAVEPOINT has been saved. In Oracle databases, a savepoint is a … Read more

A list of different types of database objects: Tables: This is a set of elements organized in vertical and horizontal fashion. Tablespaces: This is a logical storage unit in Oracle. Views: It is virtual table derived from one or more tables. Indexes: This is a performance tuning method to process the records. Synonyms: This is … Read more

Translate is used to substitute a character by character while Replace is used to substitute a single character with a word. In Oracle, both TRANSLATE and REPLACE functions are used to replace characters in a string, but they have some differences in terms of functionality. REPLACE Function: The REPLACE function in Oracle is used to … Read more