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 More1. 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 More1. 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 MoreUse 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 MoreObjective: 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 MoreObjective: 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 MorePlease use the below query. SELECT name FROM sys.user$ WHERE ext_username IS NOT NULL AND password = ‘GLOBAL’;
Read MoreThis 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 MoreTo 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 MorePlease 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 More