5 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 MoreData template in Oracle BI Publisher 10g
Objective: To generate reports from OBIP using data template SQL queries. Scenario: Customer has given a requirement to develop the report in OBIP. While developing it, developer came to know…
Read MoreGenerate DDL source code using Oracle SQL
Objective: To generate DDL source code using Oracle SQL. Scenario: Customer asks us to generate all the DDL source code for some database objects. So I just found the little…
Read MoreSplit by count excel report in Oracle BI Publisher 10g
Objective: To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Open the Excel. (See below image) Step…
Read More