The Virtual Room (500)

Discussions Replies Latest Activity

First PocketBook App for Database Administrators

Dear DBA Friends,   We are very happy to announce that dbaBuddy, the IOS (ipad and iphone) application specifically designed for database a…

Started by Uma Lakshman

0 Sep 20, 2012

What's your way to implement SQL join and distinct etc. functions?

Let’s talk more today. The example data is from 2 tables of the classical Northwind database: Orders table with the main fields: OrderID, …

Started by Jim King

0 Sep 20, 2012

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


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

Notional Pool Setups

Hi All,

I have a requirement to setup a Notional Cash pool setups between pool leader and subaccount,

Please let me know what are the setups required to complete this.



Posted by Kishore on September 14, 2014 at 11:00pm

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

© 2014   Created by Steve Karam.

Badges  |  Report an Issue  |  Terms of Service