Skip to main content

Oracle Forms Developer - Code Location

This column has focused on where and how to define code in Oracle Database, but the same rules and logic apply to the Oracle Developer environment. I suggest these guidelines:

If your program could be useful on both the server side and the client side, move it to the server, because it can be invoked from both sides there.

If the program is used only in and relevant to client-side modules (it may, for example, manipulate the contents of a field in a form) and you think or know that it will be useful in more than one module, put it into a shared library.

If your client program is very specific to a current form or report, define it within that module.
Location: Chennai, Tamil Nadu, India

Comments

Post a Comment

Popular posts from this blog

Oracle Developer Technical Interview Questions

Here i am putting all the questions i had faced during my interviews ... Interview at “3i InfoTech”, Chennai:  1) What is flow of execution of WHEN-NEW-FORM-INSTANCE, WHEN-NEW-BLOCK-INSTANCE, and WHEN-NEW-ITEM-INSTANCE? 2) What is PRE-QUERY and POST-QUERY? When these triggers will fire? 3) If the object library with some blocks and triggers if a form inherited that object library if u doesn’t need some trigger to be inherited the can u delete that trigger from that form? 4) How u can call a report from a form? Which property u has set in runtime? 5) If u create a relation between two blocks in the form what are all triggers it will create? 6) What is a ref cursor? 7) To call a form which type of built-ins u has to use? 8) What is the main difference between expand and variable property for a text item in reports. 9) In a report layout there is accepted and rejected fields and it has a parameter when u run the report based on the parameter the output should sh...
Post a Comment
Read more

Difference Between CASE and DECODE?

– CASE is a expression – DECODE is a function - CASE expression is ANSI SQL Statement - DECODE is specific to Oracle Syntax - CASE syntax contains WHEN and THEN  - DECODE will not have this - CASE allow expressions or Scalar Sub query Expressions inside the CASE statement - DECODE won't allow expressions inside the DECODE function
1 comment
Read more

Communicating with a RDBMS Using SQL

What is SQL? SQL Stands for Structured Query Language. I t is the  international  standard language for relational database management systems. It is useful for  accessing and manipulating data in a databases.  To access the database, you execute a structured query language (SQL) statement, which is the American National Standards Institute (ANSI) standard language for operating relational databases.
Post a Comment
Read more