BEGIN dbms_application_info.set_client_info(101); END; • In this example 101 is the ORG_ID for the Operating Unit or you could have use...
oracle SQL:Merge Statements
The MERGE statement was introduced in Oracle 9i to conditionally insert or update data depending on its presence, a process also known a...
Oracle SQL :Using ROWNUM in order by clause
ROWNUMBERING WITH AN ORDER BY CLAUSE One of the most often uses of the pseudo column ro...
Oracle APPS: sr Technical Jobs
We have requirement for 6 months contract period in HYD Experience :7+years mail resumes ebiztechnics1@gmail.com NP:1 month
Oracle SQL : Oracle 12 C features Part 4
Feature 1: Booleans in dynamic PL/SQL : In Oracle 12c we can pass Boolean variable as parameter in functions,procedures and packages Bo...
Oracle SQL :12 c features:Invisible Columns
Invisible Column SQL> create table emp4 (col1 number, col2 number invisible); SQL> desc emp4 Name Null? Type _____________...
Oracle APPS:Order Managment Issues and Solutions
1)Warning: The Ship Confirm option selected will unassign all the lines from delivery We have applied hold during ship confirm. and below m...
Oracle Database 12c: joining and outer joining with collections
Oracle Database 12c has extended the SQL syntax and functionality for joining with collections in such a way that the call to the PL/SQL fu...
Oracle SQL Oracle 12 c:New Features Part 3
In Oracle 12c, you can use: truncate table <Parent> cascade; • Must have defined the FK as ON DELETE CASCADE Session Sequences: ...
Oracle SQL: Bulk Collect TIPS
Bulk Collect Basics The PL/SQL engine then continues processing until the next row is required, and the process repeats. A context swit...
Oracle APPS JOBS :Finance/SCM/HRMS technical with 3 years of exp with Onsite(Middle East) Base Location :HYD
We have a requirement with 3+years of experience 1)Oracle Finance/SCM Technical 2)OrACLE HRMS Technical Base Loc:HYD .Needs to trav...
Oracle APPS: ADF Training for Beginners with sample Project
Starting Oracle APPS ADF For beginners training from next week. Course Content Course Objective : To help students buil...
Oracle APPS Jobs:Oracle HRMS functional
We have requirement on the following areas Oracle Hyperion Planning Functional Consultant Oracle HRMS Functional with Taleo exposur...
Oracle APPS: Oracle APPS Testing Suite(OATS)-Jobs
We are looking for OATS Professionals with 3.5 year experience (multiple positions) Please share resumes to ebiztechnics1@gmail.com ...
Oracle APPS :Financial Functional Consultant:Saudi :Riyadh
We need a Oracle Financial /FAH Consultant with minimum 2 implementation on R12 version. It is urgent requirement with minimum placem...
Oracle APPS:Fresher's recruitment Drive 2015
We need trained Oracle APPS functional/Technical resource who passed out in 2013/2014/2105.60% from Xth to B.Tech/M.C.A. They have to fo...
Oracle APPS; Subledger Accounting(SLA) Snapshot
Subledger Accounting: Subledger accounting is a new product in R12 which significantly enhances the accounting support across the E-Busine...
Oracle APPS: Recruitment:(Functional.Techno Funnctional/DBA multiple Posisions)
Job Location:Chennai For another client PL/SQL Developers for Chennai Location Interested Candidates can share their resumes asa...
Oracle 12 C Features:Sequence Usage in Table Creation
In Oracle 12c, it is now possible to specify the CURRVAL and NEXTVAL sequence pseudocolumns as the default values for a column. You shou...