Drag and Down Using Oracle Apex
1. Overview This document explains how to create a Drag and Down the rows using Oracle APEX. 2. Technologies and Tools Used The following technologies has been used to achieve…
Read MoreReturning Clause in Oracle Plsql
Use RETURNING Clause to Avoid Unnecessary SQL Statements 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an…
Read MoreUse of Flashback in Oracle
Objective: With flashback feature you can recover your table or data, perform queries that return past data in Oracle 19c. The Points to be noted that,The flashback cannot be usable…
Read More5 different ways to find TOP N queries
Objective: Let us write five different queries to list the top 4 highest paid employees from EMP table. Methods: 1) Using ROWNUM 2) Using ROW_NUMBER () 3) Using RANK() 4)…
Read MoreQuery to check whether database has any externally authenticated SSL users
Please use the below query. SELECT name FROM sys.user$ WHERE ext_username IS NOT NULL AND password = ‘GLOBAL’;
Read MoreApplying Redhat patching
This is for applying redhat patches and after reboot the server login to the server sudo yum update -y sudo yum check -update | wc -l the count should be…
Read MoreOracle Date Time Function Some Use Cases
To get the first date of the current month: select sysdate “date” from dual /*Current Date */ union all select trunc(sysdate,’MONTH’) from dual /*getting first day of the month*/ Result:…
Read MoreQuery to generate Baseline Script for a SQL_ID in Oracle Database
Please use the below query. col sql_text for a60 wrap set verify off set pagesize 999 set lines 155 col username format a13 col prog format a22 col sid format…
Read MoreMultiple sheet excel report template generation in Oracle BI Publisher 10g
Objective: To create template for generating multiple sheet excel in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Excel contains the below template with Sheet1 and 2…
Read MoreMultiple sheet excel report in Oracle BI Publisher 10g using data template SQL Query
Objective: To generate multiple excel sheet report from OBIP using data template SQL queries. Scenario: Customer needs multiple sheets excel report from OBIP. While developing it, developer came to know…
Read More