Join the https://t.me/OracleApps88 group or message me at @apps88 (https://t.me/apps88)
or (+91) 9059574321 in Telegram, to get more information on Oracle
EBS R12/Cloud (Fusion) applications.
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:
This blog is a treasure for any ebs tech/func consultant.
True that!
Huge information is available...............
very good information
it's good for everyone who want to know oracle as a whole
O My God Very huge info and am fear to learn all this concept
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
Great Job Sir.....Hats off to you
Good work done sor
All information is available on this site which required for oracle apps. Thanks a lot for providing publicly.
good information provide by you thank you sir.
Thank u so much sir...
Gold content it is❤️
Post a Comment