+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
How To Find Missing Number?

Code sql:
---------------------------------------------------------------------------------
CREATE TABLE test2 (sno NUMBER);
---------------------------------------------------------------------------------
INSERT INTO test2 VALUES(1);
...
Read More Read More
Published by
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

Solution
---------

Hi All,

Recently I came across the above error.

I created one Global Temporary Table and insert the data in to that table like ...
Read More Read More
Published by
The below code is forr a Program used to submit a concurrent program (XML Publisher) from backend.

Code sql:
DECLARE
-- This program is used to submit an concurrent program (XML Publisher) from back end.--
l_responsibility_id NUMBER;
l_application_id     NUMBER;
l_user_id
...
Read More Read More
Published by
Recently I come across one issue. I have a XMLP report which is giving excel output. So when I ran the report, In invoice_number column it is showing 2.01213E+12

But actually Invoice number is 2012131000014.

If it is 2012131000015 also it will show as 2.01213E+12.
...
Read More Read More
Published by
Page Break Before:

The Page Break Before property indicates that you want the object to be formatted on the page after the page on which it is initially triggered to print. Note that this does not necessarily mean that all the objects below the object with Page Break Before will move ...
Read More Read More
Published by
The Oracle database is an object-relational database management (RDBMS) system developed by Oracle. The data are physically stored in the Oracle database in the form of data files. Today, oracle database is widely used across various organizations. It has various features and advantages including the ...
Read More Read More
Published by
Purpose

This code is a generic version of a function posted recently by Jagadekara to calculate the sum of all digits of a given number up to a single digit which was limited to a 12 digit number.

This new function aims at removing this restriction and works for any number ...
Read More Read More
Published by
Code sql:
SELECT fif.id_flex_name
      ,fifs.id_flex_structure_name
      ,ffksv.parent_segment_name
      ,ffvrv.flex_value_rule_name
      ,ffvrv.description
      ,ffvrv.error_message
      ,decode(ffvrl.include_exclude_indicator,'I','Include','E','Exclude')
...
Read More Read More
Published by
Code sql:
CREATE OR REPLACE FUNCTION XXST_SUM_OF_DIGITS(p_num NUMBER) RETURN NUMBER IS
  a NUMBER(12);
  b NUMBER;
  c NUMBER;
  d NUMBER;
  e NUMBER;
BEGIN
    a:=P_NUM;
    b:= nvl(substr(a,1,1),0)+nvl(substr(a,2,1),0)+nvl(substr(a,3,1),0)+nvl(substr(a,4,1),0)
...
Read More Read More 6 Comments
Published by
Hi All,

The following Query gives you the PO Details in R12 which have receipts and which don't have Invoices.

Code sql:
SELECT asp.vendor_name
      ,pha.segment1
      ,pha.creation_date po_date
      ,pha.type_lookup_code
      ,SUM(pla.unit_price*
...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7