Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

PL-SQL

Please Like and Share our FaceBook page to get more details on Oracle Applications
https://www.facebook.com/pages/Oracle-Applications/712588392100243

Topic
Link
SQL
EMP, DEPT and SALGRADE Tables Data
SQL – Oracle SQL Training Manual
Oracle Structured Query Language(SQL) Material
Oracle SQL Logical Queries
Oracle SQL Queries
Oracle SQL Scripts
Oracle SQL Queries
Oracle SQL Scripts
Abstract Datatypes in Oracle
Difference Between WHERE Clause AND HAVING Clause in Oracle
Common SQL Commands
SQL Queries
Oracle SQL Commands
Data types for Oracle 8 to Oracle 11g
Oracle Indexes
Oracle Join Queries
DATA BASE MANAGEMENT SYSTEM  
SQL and PL SQL
Query Tuning
Oracle SQL Notes
Oracle  SQL Sample Queries
Oracle DML, DDL and Constraint Statements
Explain plan in Oracle
Oracle XML Operations XMLType, UPDATEXML, EXISTSNODE, XMLELEMENT, XMLATTRIBUTES, XMLFOREST, XMLAGG, XMLROOT and Basic XML Parsing via PL/SQL
Oracle SQL Date column Scripts
Query to get the Number of Seconds or Minutes or Hours between 2 given days
Oracle Fiscal Year Calendar Query
Complex Queries in SQL ( Oracle )
Calendar Query in Oracle
Oracle PL SQL - Tables/Indexes
Difference Between ‘YYYY’ and ‘RRRR’ in Date Format
How to Delete Duplicate Rows in a Oracle Table
Query to get the Number of Years, Months and Days between two given dates
Cumulative Sum in Oracle
Oracle CLOB(32767)
Complex Queries in SQL ( Oracle )
oracle SQL Query For Calender
Advance SQL Commands
Views in Oracle
DML Operation in Oracle
Sub Queries
General Functions in Oracle
Conversion Functions in Oracle
Number Functions in Oracle
Date Functions in Oracle
Arthemetic Functions In Oracle
Oracle SQL Functions
Date Between and Date Range query
SQL Queries
Oracle SQL Functions
Oracle SQL and PL/SQL
LINUX & ORACLE QUICK REFERENCE
Basic SQL queries in Oracle
PL/SQL
PL/SQL – Oracle PL/SQL Training Manual
Oracle SQL and PL/SQL
Oracle PL/SQL Coding Standards and Naming Conventions
Oracle PL/SQL Performance Tips
SQL and PL SQL
Oracle PL/SQL Useful Programs 1 of 3
Oracle PL/SQL Useful Programs 3 of 3
Oracle PL/SQL Bulk Collect Example
Oracle PL/SQL Report
Oracle PL/SQL Collections with Examples
Oracle PL/SQL Coding Standards
Oracle REF Cursor Example
Oracle PL/SQL Bulk Collect
ORACLE BULK COLLECT
Oracle Collections Examples
Oracle Bulk Insert
Parametrized Function example in PL/SQL
Autonomous Transactions (Commit and Rollback)
Oracle PL/SQL Normal Insert and Bulk Insert
Oracle PL/SQL Advanced Queuing Technology
Oracle PL/SQL Bulk Bind
Multiset Operators in PL/SQL
Oracle PLSQL - BULK COLLECT
PL-SQL Examples
Oracle and PL/SQL
CONTROL STRUCTURE STATEMENT IN PL/SQL
PL SQL
PL SQL Cursors
Oracle PL SQL Codes
http://oracleapps88.blogspot..com/2012/12/oracle-pl-sql-programs.html
Interview Questions and Answers - FAQS
Oracle SQL Logical Queries
Oracle FAQs
Oracle SQL Queries
Oracle PL/SQL FAQs
Autonomous Transactions (Commit and Rollback)
Complex Queries in SQL ( Oracle )
Parametrized Function example in PL/SQL
Difference Between WHERE Clause AND HAVING Clause in Oracle
ORACLE BULK COLLECT
SQL/SQL Plus Interview Questions and Answers
PL/SQL Interview Questions and Answers
PL/SQL Interview Questions and Answers
PL/SQL Interview Questions and Answers
Oracle Interview Questions and Answers
Oracle Interview Questions and Answers
Oracle PL/SQL FAQs
http://oracleapps88.blogspot.com/2016/02/oracle-plsql-interview-questions-and_15.html
Documents
 SQL - Object Oriented Programming Basics 
 SQL - Stored Procedure Example 
 SQL - Triggers and Built-ins
 SQL and PL/SQL Interview Questions and Answers 
 SQL Basics 
 SQL Document 
 SQL Document 
 SQL Documents 
 SQL Faqs 
 SQL Queries and Answers 
 SQL Training Document 
 PL SQL 
 Pl Sql 
 PL/SQL Documents 
 PL/SQL Programming Coding Standards and Naming Conventions 
 PL/SQL Programs 
 PL-SQL - DBA and PL-SQL Interview Questions and Answers 
 PL-SQL Basics 
 PL-SQL Training Document 
 DBA – Important Apps Questions

 Document Name 
Link
Query To Get The Working Dates and Number Working Days between Two Dates
Oracle Application Framework (OAF) Useful Links from Different Websites
Oracle Application Framework (OAF) Useful Links from Different Websites
Oracle SQL, PL/SQL and DBA Interview Questions and Answers (FAQs)
UTL_FILE Examples - FOPEN, PUT_LINE, GET_LINE, FCLOSE, FCOPY, FRENAME, FREMOVE
Oracle PL/SQL Collections
Usage of Custom Library CUSTOM.pll in Oracle Personalizations
Oracle PL/SQL Programs
Oracle PL/SQL Collection Metarial
Query to Get Invalid Objects from Database
Oracle Report to XML Publisher Report Migration
Multile Queries in XML Publisher Data Template
Steps On How To Enable Debug For BI Publisher Desktop When Developing Templates
Oracle Conversion and Interface Strategy
Oracle SQL Loader Process Details
Oracle Workflow Training Manual
Query to get Patch Details




13 comments:

Atul Vishwakarma said...

This blog is a treasure for any ebs tech/func consultant.

Ravi P Hunachannavar said...

True that!

Unknown said...

Huge information is available...............

Unknown said...

very good information

Anonymous said...

it's good for everyone who want to know oracle as a whole

Unknown said...

O My God Very huge info and am fear to learn all this concept

Unknown said...

Hi There,

Your writing shines like gold! There is no room for gibberish here clearly. You nailed it in Oracle Applications.
can any one suggest me on my below issue

I created one table and try to insert the log into the table by selecting the values from - v$session.
I have proper authorities on v$session - table , and I am able to query from out side of the procedure.

actually i am planning to use this process to capture the log when ever i have an issue in the program.

CREATE TABLE err

(

Sid NUMBER ,

OsUser VARCHAR(20),

Machine VARCHAR(20),

Process VARCHAR(12),

Program VARCHAR(100),

Module VARCHAR(100),

Action VARCHAR(100),

ErrorMsg VARCHAR2(4000),

Backtrace CLOB ,

Callstack CLOB

);

PROCEDURE
create or replace procedure errproc as

begin

insert into err

(

Sid,

OsUser,

Machine ,

Process ,

Program ,

Module,

Action

ErrorMsg ,

Backtrace

-- Callstack

)

select

Sid ,

OsUser,

Machine,

Process,

Program,

Module,

Action

DBMS_UTILITY.format_error_stack,

DBMS_UTILITY.format_error_backtrace

--DBMS_UTILITY.format_error_call_stack

FROM v$session

WHERE sid = sys_context('USERENV','SID');

end errproc ;

I am unable to create this procedure ,getting the below error

[Warning] ORA-24344: success with compilation error

30/12 PL/SQL: ORA-00942: table or view does not exist

4/3 PL/SQL: SQL Statement ignored

(1: 0): Warning: compiled but with compilation errors.


Once again thanks for your tutorial.

Gracias
Preethi

Unknown said...

Great Job Sir.....Hats off to you

sampath said...

Good work done sor

Anonymous said...

All information is available on this site which required for oracle apps. Thanks a lot for providing publicly.

Parikshit said...

good information provide by you thank you sir.

Anonymous said...

Thank u so much sir...

Anonymous said...

Gold content it is❤️

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect