 Related Questions Boiler plate Images are static images (Either vector or bit map) that you import from the file system or database to use a graphical elements in your form, such as company logos and maps. Image items are A record group is an internal Oracle Forms that structure that has a column/row framework similar to a database table. However, unlike database tables, record groups are separate objects that belong to A query record group is a record group that has an associated SELECT statement. The columns in a query record group derive their default names, data types, had lengths from the database columns referenced Yes Fires when oracle forms first marks a record as an insert or an update. The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit What is the difference between $$DATE$$ & $$DBDATE$$$$DBDATE$$ retrieves the current database date$$date$$ retrieves the current operating system date. Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to Fires during the execute query and count query processing after oracle forms constructs the select statement to be issued, but before the statement is actually issued.The pre-query trigger fires just before If the application is running very slow? At what points you need to go about the database in order to improve the performance? Read Answers (4) | Asked by : j.w If your database is running slow from last 2 hrs.you can't wait for Statspack report generation. What will be your first step to handle the problem? Where can be the problem? Latest Answer : Remove unnecessary joins, too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
