priya

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

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 a name for tables. Oracle Database consists of … Read more

Hash cluster is a technique to store a data in hash table and improve the performance of data retrieval. Hash function is applied on table row’s cluster key value and store in hash cluster. In Oracle, a hash cluster is a type of table cluster that uses a hash function to distribute rows among a … Read more

Save points are used to divide a transaction into smaller parts. It allows rolling back of a transaction. Maximum five save points are allowed. It is used to save our data, whenever you encounter an error you can roll back from the point where you save your SAVEPOINT. In Oracle database, a savepoint is a … Read more