The Virtual Room (498)

Discussions Replies Latest Activity

Help Required (Load Special Characters through SQL Loader)

Hi All, Please find below details. I am using Oracle 11g. Records from CSV file: AODEFH;FHG Süd 1)  I am trying to load above record throu…

Started by Divyang Shah

0 Sep 11, 2012

How can your guys implement Basic functions of SQL by other ways?

It is known to us that SQL users have to finish composing all codes and then run them all at one time, resulting in a poor ability for inte…

Started by Jim King

0 Sep 11, 2012

Including Freight in Customer Sales Tax Calculation

In the Oracle Receivables User Guide, page 2-16 states "By default, Receivables does not calculate tax on freight charges. However, you can…

Started by Phil

0 Aug 30, 2012

Mass Allocation in R12.1.1

Hi, Iam getting an error while running mass allocation. Please guide me on this. Regards, sudheer

Started by Sudheer M

1 Aug 22, 2012
Reply by Eddie Awad

auto invoice import program completed with error

Can anyone help to solve this issue?  Issue in India Localisation.  User wrongly selected Tax category with Excise & VAT for service it…

Started by Gunasundari

0 Aug 21, 2012

Replikasi database

tman2, numpang nanya. saya masih newbie di oracle, saya inging belajar replikasi database dari oracle ke mysql. caranya gmna ya??ada yang t…

Started by donal siagian

0 Jul 10, 2012

Need help on Sql%Not Found

After an Update statement, Sql%NotFound is being validated. Sql%NotFound validates to true even though a record matching the update conditi…

Started by Pradeep Tiptur Nagaraja

1 Jun 29, 2012
Reply by Eddie Awad

Sr. IT Analyst - Oracle Financials (Portland, Oregon)

Hey there! I am a Recruiter working on a couple of Oracle positions and I wanted to spread the word. Our client is hiring for full time Sr.…

Started by Heather Carrion

0 Jun 27, 2012

EBS 11i forms are not opening on Linux (Ubuntu).

EBS 11i forms are not opening on Linux (Ubuntu). I installed followiing things but still forms were not opening on linux client, windows cl…

Started by Mahender Singh

1 Jun 21, 2012
Reply by Abdul Mannan

Using WebCam in Forms 6i

Hi, How I can use WebCam in Forms 6i to take pictures on-line and store it in Oracle 10g? Thank's Arie

Started by Arie Solnik

1 Apr 15, 2012
Reply by AneebUrRehman


Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Join cases between related tables in data computing and analytics

Related computing can be: Inner join or outer join. The outer join can be further divided into left join, right join, and full join. With esProc, such kinds ofrelated computing can be easily implemented. In the discussion below, we will introduce the join operations with some examples using the table emp and table sOrder.

Table structure:

The table emp stores the employee data table, in which the…


Posted by Jim King on August 25, 2014 at 1:35am

Oracle RAC Classes

Contact me for Oracle High Availability Training / Online Classes - Dubai

Posted by Shanmugam on August 18, 2014 at 1:00am

Code Examples of In-Memory Grouping for more efficient data computing and analytics

It is convenient to realize some common in-memory grouping with esProc, such as, equal grouping, alignment grouping and enumeration grouping. They are to be illustrated with the following examples.

Equal grouping 

Grouping basis of equal grouping is certain fields (or computed columns derived from fields) within a data set. Each group is a subset of original data set.

Case description: Group sales orders by the year. …


Posted by Jim King on August 15, 2014 at 12:21am

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service