Multiple files upload in Oracle
External table Data load with Delimiter Introduction: to upload the data with the delimiter and special character. Cause of the issue: In the control file having issue to load…
Read MoreHow to overcome ORA-01102: cannot mount database in exclusive mode?
Introduction: While starting the Oracle database in the mount stage was failed (ORA-01102: cannot mount database in exclusive mode) with the below error Error: SQL> alter database mount; alter database…
Read MoreCreating Data Source in WebLogic Server
1. Overview This document talks about how to create a data source for java project using Oracle Web logic server. 2. Technologies and Tools Used The following technologies have been…
Read MoreDrag 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 More