Question 1. What is a table Cluster?Answer: A table Cluster is a group of related tables that share common columns are store related data in the same block. Question 2. What is EXISTS usage in SQL? Answer “exists” statement helps us to do the job of the If statement. The main query will get executed if …
Oracle Interview questions Read More »
Cloning an Oracle Home is a process where you copy the Oracle Home directory from one server (source) to another server (destination) or to a different location on the same server. The goal is often to replicate an Oracle software installation without the need to perform a full installation from scratch. Oracle has different steps …
We generally write FND_FILE statements in concurrent programs for debugging, logs, and various other messages These are visible in Concurrent request logs and out once the concurrent program completes only If we want to see the logs and out for the running concurrent request, then we need to find the temporary log and out file …
How to find the FND_FILE output of the running concurrent request Read More »
srvctl commands is an important tool to manage the Oracle database in the RAC environment and Oracle restarts env(Single node env with ASM). This can be used to stop, start, find status, and other things in the cluster or the server. Let’s review those command srvctl commands srvctl is a utility in $ORACLE_HOME/bin and it …
This is part of the Oracle SQL tutorial and has good examples and explanations on Regexp in Oracle. regexp in oracle The following functions have been introduced REGEXP_LIKE: Similar to the LIKE operator, but performs regular expression matchinginstead of simple pattern-matchingREGEXP_REPLACE: Searches for a regular expression pattern and replaces it with areplacement stringREGEXP_INSTR: Searches for a given …
Regexp in oracle : functions ,Regular expression Read More »
Here are some of the Top Useful Queries for SQL Patch in Oracle Database Query to find the hints associated with a SQL Patch select cast(extractvalue(value(x), ‘/hint’) as varchar2(500)) as outline_hints from xmltable(‘/outline_data/hint’ passing (select xmltype(comp_data) xml from sys.sqlobj$data where signature = (select EXACT_MATCHING_SIGNATURE from v$sql where sql_id = ‘&SQL_ID’))) x; How to find all …
Top SQL Patch Queries in Oracle Database Read More »
