Find the Invalid Email Address using Oracle SQL and PL/SQL
Objective: To find the validity of the email address using Oracle Pl/sql and to find the invalid email address from a object like table using Oracle Sql. Using Pl/Sql: DECLARE…
Read MoreExcel Template in oracle Apex for Excel Upload Page using JavaScript and Oracle pl/sql
Objective: The Excel Upload Page in Oracle Apex Involves Excel Upload template design. Usually the templates will be stored in Shared Components Workspace File and through button click JavaScript call,…
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 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