Ans: $IAS_ORACLE_HOME/Apache/modplsql/cfg This file is used by mod_plsql component of Apache to connect to database. So when you type url http://hostname:port/pls/SID , whenever Apache(11i Web Server) finds that request is for /pls/ then Apache delegates this request to mod_pls c...
SQL> select * from v$version; The command returns the release information, such as the following:Oracle9i Enterprise Edition Release9.2.0.7.0- ProductionPL/SQL Release9.2.0.7.0- ProductionCORE9.2.0.7.0ProductionTNS for 32-bit Windows: Version9.2.0.7.0- ProductionNLSRTL Version9.2.0.7.0- Product...
Format triggers are PL/SQL functions executed before the object is displayed. The trigger can be used to dynamically change the formatting attributes of the object. The function must return a Boolean value (TRUE or FALSE). Oracle Apps Financials: Some Interview questions I am giving below some...
17. Oracle PL-SQL 18. Oracle Programmatic Constructs19. Oracle Scenarios20. Oracle Security21. Oracle Technology Network (OTN)22. SQL Plus SAMPLE QUESTIONS Q. ) Explain When can hash cluster used?Ans: Hash clusters are useful in cases where :(i) There is a uniform, even and predictable ...
Interview Questions and Business Opportunities 1968Oracle EBS specialists ne... 12-24-2019, 01:18 PM by viggora Board Statistics Who's Online[Complete List] 74 users active in the past 15 minutes (14 members, 0 of whom are invisible, and 57 guests). ...
Oracle Interview Questions provides you a wide range of questions that can be asked during a Interview. Application answers most commonly asked interview questions and has been categories for ease.This app is unique in that it helps you master the most commonly asked questions, instilling you wit...
Passing User Name to PL-SQL through Parameter. (Oracle APPS , Oracle EBS) In this post, I will Continue reading Concurrent Programs Related Leave a comment Understanding and Using API User Hooks Posted on September 10, 2011 by Administrator Understanding and Using Oracle HR API User Hooks ...
If you have some more advanced skills in SQL, PL/SQL, and JavaScript, you can use APEX as a low-code platform. You’ll be able to develop your application using all that Oracle Database has to offer. Keep in mind that APEX is bundled in the database – you get it anyway. So, if...
NoSQL Database is a sharded (shared-nothing) system which distributes the data uniformly across multiple shards in a cluster. Within each shard, storage nodes are replicated to ensure high availability, rapid failover in the event of a node failure and optimal load balancing of queries. NoSQL...
Oracle VM 2 users may use the traditional 2-node interview shown below, simply type yes at the only required key/question during first boot console interview: 'com.oracle.racovm.netconfig.interview-on-console' 'Do you want to access the 2-node RAC interview on console ? [YES|NO] ...