Database Archives

View java class source in oracle database

Application Object Library, Database / admin

View java class source in oracle databasejava class code that is compiled in databasejava class is compiled successfully and is validquery java object in Oracle database Click HERE for steps to compile java object in Oracle database

View java class source in oracle database Read More »

Load Java source code in oracle database

Application Object Library, Database / admin

Load Java source code in oracle databaseCREATE OR REPLACE AND RESOLVE JAVA SOURCECompile java code in oracle databaseCall java in oracle apps database procedurewriting java code in oracle databasecreate java code in oracle database Below is a sample java class that we will compile and call from database function Step 1: Compile the below java

Load Java source code in oracle database Read More »

Query to find and remove Oracle database locks

Database / locks

Query to find and remove Oracle database locksOracle database locksoracle lock tableblocking session in oracleoracle deadlockoracle lockoracle locked objectsquery to check locks in oracle databaseoracle table lock queryoracle show locksfind blocking session in oracleoracle db lockoracle check locksquery to find locked objects in oracleoracle check table lockHow to find the Oracle database locksHow to remove

Query to find and remove Oracle database locks Read More »

PL-SQL code to write a file

Database / Amol Jadhav

PL-SQL code to write a fileOracle apps ebs plsql to write a filehow to write a file using plsql

PL-SQL code to write a file Read More »

PL-SQL code to read a file

Database / Amol Jadhav

PL-SQL code to read a fileOracle apps ebs plsql to read a filehow to read a file using plsql

PL-SQL code to read a file Read More »

Query to find second and third highest value

Database / Amol Jadhav

Query to find second and third highest valueSQL query to find second and third highest value in empid columnReplace empid column name with salary to apply the logic on salary column

Query to find second and third highest value Read More »

PL-SQL Procedure to send email with attachment

Application Object Library, Database / Amol Jadhav

PL-SQL Procedure to send email with attachmentHow to send email using plsqlHow to send email with attachment using plsqloracle send email from databaseoracle send email with attachment utl_smtp 1. Compile the below procedure XXSEND_EMAIL in the database 2. Call the procedure with below anonymous block Please note that the Workflow mailer should be up and running

PL-SQL Procedure to send email with attachment Read More »

Query to get the details of the lock in the database

Application Object Library, Database / Amol Jadhav

Query to get the details of the lock in the databaseHow to find database locksOracle Apps EBS database locks