Quick Pick and Quick Codes
Differences between Quick Pick and Quick Codes.Quick Pick is variable because it selects values from user-defined tables. Quick Code is static & it selects values from system table. Quick Code is faster than Quick Pick because it uses internal CACHE.
Rule based optimization in Oracle Apps
More than a decade ago, all Oracle databases used what is now called rule-based
optimization, which uses a fixed strategy to optimize a query's results......
Profile option “Node Trust Level
If this profile option is set to some external value against a server, then it
signifies that the specific middle tier is External......