Oracle uses PL/SQL, which is an extension of SQL. PL/SQL generates more potent SQL queries by fusing the processing power of procedural languages with SQL's data manipulation capabilities. It tells the compiler what to do using SQL and how to do it using a procedural method. 11) What is...
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...
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...
Interview Questions and Business Opportunities 1968Oracle EBS specialists ne... 12-24-2019, 01:18 PM by viggora Board Statistics Who's Online[Complete List] 464 users active in the past 15 minutes (0 members, 0 of whom are invisible, and 462 guests). ...
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 ...
Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers...
FND_FILE in oracle apps Oracle,Oracle Ebuisness Suite In this post, we will discuss FND_FILE in oracle apps, how it works, troubleshooting the FND_FILE issues What is FND_FILE select cp.plsql_dir, cp.plsql_out, cp.plsql_log from fnd_concurrent_requests cr, fnd_concurrent_processes cp...
Database Administration | Oracle | Oracle Training | DBA Support | Oracle 12c DBA | GoldenGate | GoldenGate 12c | DBA Interview Questions | Goldengate Interview Questions | Natik Ameen
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...
The magic of PL/SQL revealed in three questions May 2021 Do you know when to anchor, when to loop, and when not to make? Read more Groundbreakers Podcast: Oracle’s Sandesh Rao on building AI tools for Oracle Autonomous Database April 2021 Oracle VP for AIOps and machine learning for...