View java class source in oracle database
--Run below query to check if the java class is compiled successfully and is valid.
SELECT *
FROM dba_objects
WHERE object_type IN ('JAVA SOURCE')
and object_name like '%TEST_JAVA_PKG%';
--Run belo...Database
9 posts
Load Java source code in oracle database
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 […]
Query to find and remove Oracle database locks
-- Use below query to find locked objects
select
c.owner,
c.object_name,
c.object_type,
b.sid,
b.serial#,
b.status,
b.osuser,
b.machine
from
v$locked_object a ,
v$session b,
dba_objects c
where
b.sid ...PL-SQL code to write a file
PL-SQL code to write a fileOracle apps ebs plsql to write a filehow to write a file using plsql
PL-SQL code to read a file
PL-SQL code to read a fileOracle apps ebs plsql to read a filehow to read a file using plsql
Query to find second and third highest value
SELECT *
FROM (SELECT ROWNUM row_num, b.*
FROM ( SELECT e.*
FROM emp e
ORDER BY empid DESC) b)
WHERE row_num IN (2, 3)PL-SQL Procedure to send email with attachment
CREATE OR REPLACE PROCEDURE XXSEND_EMAIL (p_filename1 IN VARCHAR2,
v_subjectline IN VARCHAR2,
o_errbuf...Query to get the details of the lock in the database
SELECT NVL (s.username, 'Internal') username,
NVL (s.terminal, 'None') terminal,
l.SID || ',' || s.serial# KILL,
s.audsid ...Query to find Table size
SELECT owner, table_name, TRUNC (SUM (bytes) / 1024 / 1024) MB
FROM (SELECT segment_name table_name, owner, bytes
FROM dba_segments
WHERE segment_type IN ('TABLE', 'TABLE PA...