This is a good article on the subject http://www.dbspecialists.com/files/presentations/semijoins.html
Sunday, April 11, 2010
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
During my work, sometimes I come across some information that I am sure to forget in a given time period. So I started this blog to post such information for future use. If it is of any use to you, please let me know.
Posts
Followers
Categories
- Accounts Payable (28)
- Accounts Receivable (18)
- API Examples (1)
- Can You Please answer these Questions (1)
- DBA Tips for developers (22)
- Example Scripts (4)
- FND (Application Object Library) (54)
- How to Debug (11)
- Linux (2)
- Oracle Alert (1)
- Oracle Analytic (1)
- Oracle and XML (3)
- Oracle Forms (7)
- Oracle General Ledger (3)
- Oracle Inventory (4)
- Oracle Magzine Articles (2)
- Oracle Order Management (14)
- Oracle Payments (22)
- Oracle Pricing (7)
- Oracle Projects (4)
- Oracle Purchasing (3)
- Oracle Reports (3)
- Oracle Support (2)
- Python Programs (1)
- Ready for Delete (2)
- References (4)
- Release 12 Upgrade (7)
- Self Service (1)
- SQL Developer (2)
- Sql Examples (4)
- SQL Hints (1)
- Sqlplus Tricks (15)
- Trading Community Architecture (19)
- Workflows (2)
- XML Publisher (8)
- zGeneral (6)
- zMy Thoughts (4)
- zQ (1)
Total Pageviews
Popular Posts
-
Contact point such as Phone, Email or UL can be attached to a customer at multiple levels such as Customer itself, Customer's Address o...
-
This simple script shows how to use FND_PROFILE.save function. This could be of some use when you need to save multiple profile options for ...
-
Bank Account can be associated with Supplier at following levels 1. Supplier 2. Supplier site 3. Party Site 4. Party Site + Org This query c...
-
SET SERVEROUTPUT ON size 1000000 DECLARE l_req UTL_HTTP.req; l_resp UTL_HTTP.resp; l_buffer VARCHAR2(32767); l_body VARCHAR2(327...
-
This query can give details of a Oracle Application Responsibility and list of menus and functions that are excluded from that responsibil...
-
DECLARE l_phone_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type; l_email_rec HZ_CONTACT_POINT_V2PUB.email_rec_type; l_co...
-
Bank and Bank branches are stored in HZ_PARTIEES. Bank and Bank Branches have PARTY_TYPE value as ORGANIZATION. Bank_id and bank_branch_...
-
This is a simple table. I saved this query to remind myself that phone, fax and email entered on Supplier Address region are stored in hz_c...
-
DECLARE l_coa_id gl_sets_of_books.chart_of_accounts_id % TYPE; l_ccid gl_code_combinations.code_combination_id % TYPE; l...
-
I have a custom pl/sql program that applied credit memos and receipts to invoices and debit memos. At the end of program i wanted to see wha...
No comments:
Post a Comment