Oracle Articles

Pages

  • Home
  • SQL
  • PL/SQL
  • Reports
  • Forms
  • Oracle Apps
  • Java
  • Interview Referance

Interview Referance


Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Home
Subscribe to: Posts (Atom)

Search This Blog

Labels

  • AFTER PARAMETER FORM (1)
  • AFTER REPORT TRIGGER (1)
  • ALERT CREATION (1)
  • APPS (13)
  • Apps Tables (5)
  • BEFORE PARAMETER FORM (1)
  • BEFORE REPORT TRIGGER (1)
  • BETWEEN PAGES (1)
  • BI Publisher (1)
  • CASE STATEMENT (1)
  • check (1)
  • constarints (1)
  • CONTENT CANVAS (1)
  • Custom Form (2)
  • Dataloder (1)
  • Decode function (1)
  • Explicit Cursor (1)
  • foreign key (1)
  • Forms (5)
  • interface (1)
  • Interview questions (1)
  • ITEM INTERFACE (1)
  • LOV (1)
  • MENU CREATION (1)
  • MOAC Setup (1)
  • MVC (1)
  • not null (1)
  • O2C (1)
  • OAF & MVC (1)
  • OAF Architecture (1)
  • OAF Material (1)
  • OAF Page Context (1)
  • OAF Training (1)
  • OPEN -ITEM INTERFACE (1)
  • Operating Unit (1)
  • ORACLE (1)
  • Oracle Apps (21)
  • Oracle Queries (2)
  • Oracle Reports (2)
  • PL/SQL (4)
  • PL/SQL PACKAGE (3)
  • primary key (2)
  • Query Find form (1)
  • r12 (1)
  • Records (1)
  • REPORT REGISTRATION (1)
  • Report Triggers (1)
  • Report wizard (1)
  • Reports (4)
  • RESPONSIBILITY CREATION (1)
  • SQL (9)
  • STACKED CANVAS (1)
  • Table creation (1)
  • triggers (1)
  • types of constraint (1)
  • unique key (1)
  • XML (1)

Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Oracle Archive

  • ▼  2014 (1)
    • ▼  April (1)
      • HOW TO CREATE, DROP, DISABLE, AND ENABLE A PRIMARY...
  • ►  2013 (52)
    • ►  December (1)
    • ►  October (7)
    • ►  August (2)
    • ►  July (13)
    • ►  June (27)
    • ►  March (2)

Popular Posts

  • Report triggers
    Report triggers are of five types and their sequence of Execution: BEFORE PARAMETER FORM AFTER PARAMETER FORM BEFORE REPORT TRIGGER ...
  • JOIN CONDITIONS USED IN ORACLE APPS(GL,AP,AR,INV ETC)
    KEY JOINS GL AND AP GL_CODE_COMBINATIONS AP_INVOICES_ALL code_combination_id = acct_pay_code_combination_id GL_CODE...
  • Query_Find Form in Oracle Apps
    Steps To Develop a Query_Find Form in Oracle Apps Step 1:  Open Template.fmb with form builder save it with another name(XXMZ_Query_Find...
  • Login Page Creation in Oracle Form 10g
    Login Page Creation in Oracle Form 10g create table gmail(name varchar2(20) constraint pk_name primary key,pswd varchar2(20)not null) s...
  • Trace details for a concurrent request along with the log and output file location details
    SELECT 'Request id: ' || request_id, 'Trace id: ' || oracle_process_id, 'Trace Flag: ' || req.enable_trac...
  • List Concurrent Programs using a specific valueset in its parameter list
    SELECT fcp.user_concurrent_program_name, fat.application_name, fdfc.column_seq_num Seq, fdfc.form_left_prompt "Parameter Name...
  • Sql Functions
    Aggregate  functions Aggregate functions return a single result row based on groups of rows, rather than on single rows. Ag...
  • Invoice List for a Customer query
    SELECT hp.party_name customer ,hca.account_number ,rcta.trx_date ,rcta.trx_number Invoice_number ,rcta.status_trx ...
  • HOW TO CREATE, DROP, DISABLE, AND ENABLE A PRIMARY KEY
     how to   create, drop, disable, and enable a primary key   in Oracle with examples. WHAT IS A PRIMARY KEY ? In Oracle, a  primary key...
  • Order to Cash query
    SELECT hp.party_name customer ,hca.account_number ,hp.party_number ,ooh.order_number ,ooh.flow_status_code Order_st...
Simple theme. Powered by Blogger.