Oracle Notes

In Oracle, control file is used for database recovery. The control file is also used to identify the database and redo log files that must be opened for database operation to go ahead, whenever an instance of an ORACLE database begins. The control file in Oracle plays a crucial role in the functioning of the … Read more

Self join Outer Join Equi-join In Oracle, when writing subqueries, you can use various types of joins, just like in regular SQL queries. The types of joins commonly used in subqueries include: INNER JOIN: Retrieves records that have matching values in both tables. OUTER JOIN: Retrieves all records from one table and the matched records … Read more

Yes. We can create a synonym without having a base table. In Oracle, it is not possible to create a synonym without referencing an existing table, view, sequence, or another synonym. A synonym in Oracle is essentially an alias or alternate name for an object, and it must be associated with an existing database object. … Read more

Following are the different modules in Oracle forms: Form module Menu module Pl/SQL Library module Object Library module In Oracle Forms, modules are the building blocks used for designing and developing applications. The two main types of modules in Oracle Forms are: Form Modules: Form modules are used for designing the interactive user interface of … Read more

A pre-query trigger fire before the query executes and fire once while you try to query. With the help of this trigger you can modify the where clause part dynamically. Pre-select query fires during the execute query and count query processing after Oracle forms construct the select statement to be issued, but before the statement … Read more