+ Write Article

Oracle Articles Examples, Tutorials and Articles

Published by
Easy Customization

Flexibility is important. There is no way for you to anticipate all the form and database fields your end users might want, nor how each field should look as end user needs change. Using Key and Descriptive flexfields, you give end users the ability to customize your ...
Read More Read More
Published by
Introduction

Query to get the Concurrent Programs Details from backend.

SQL Code:
Code sql:
SELECT DISTINCT fcp.user_concurrent_program_name "Concurrent Program Name",fcp.description "Concurrent Program Description",
fef.executable_name"Executable
...
Read More Read More
Published by
Finding islands – 4 methods in Oracle

SQL & PL/SQL

Finding islands are classic problems in PL/SQL. The basic concept is that you have some sort of numbers, like these: 1, 2, 3, 5, 6, 8, 9, 10, 15, 20, 21, 22, 23, 25, 26. The islands problem involves identifying ranges ...
Read More Read More
Published by
Complex Queries in SQL ( Oracle )
-----------------------------------------

Hai All,

These questions are the most frequently asked in interviews.

1) To fetch ALTERNATE records from a table. (EVEN NUMBERED)

select * from emp where rowid ...
Read More Read More
Published by
This issue is particular for India.

In R12 we need to setup Legal Entity as the part of Multi Org Structure. In order to do that we need to define the Address of the Entity and initially “India” is not defined as a territory. So to define India as a territory we have to do the following ...
Read More Read More
Published by
In SQL TABLE has more importance. TABLE is a database object which is used to store the data in rows and columns wise. A table should have at least one column and maximum of 30 columns.

Table name consist names, numbers and some symbols also. The maximum length of table name is 30 characters. ...
Read More Read More
Published by
Hi viewers!

To increase the performance of any query please keep in mind the following points.

Steps to Tune the Query :
---------------------------------
  • Make sure the proper joins for whatever tables in from clause.
  • Make the joins with "ID's"
...
Read More Read More
Published by
Introduction

The following script helps you to create Table through Oracle Report.

Srw.do_sql (sqlstatement char);


Examples:
SRW.USER_EXIT('FND SRWINIT');

srw.do_sql('create table xxg4_y(ename varchar2(10))');
...
Read More Read More
Published by
Let’s see what the term Invoice Aging means? Why is it called Aging report? Where is the Aging report used? How does the Aging report work?

Why called Aging Report?

: Aging comes from the word Age. “Age” is the chronological representation of any phenomenon. Be it a person, ...
Read More Read More
Published by
Article Preview
Introduction

Finding gaps is classic problem in PL/SQL. The basic concept is that you have some sort of numbers (like these: 1, 2, 3, 5, 6, 8, 9, 10, 15, 20, 21, 22, 23, 25, 26), where there’s supposed to be a fixed interval between the entries, but some entries could be missing. The ...
Read More Read More

Page 1 of 10 1 2 3 4 5 6 7