ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> ERP CRM >> Oracle Apps >> Oracle Apps Technical
 
 


 

 
 Oracle Apps Technical interview questions  Oracle Apps Technical Interview Questions (483)
 Oracle Apps Financial interview questions  Oracle Apps Financial Interview Questions (589)
 Oracle Apps Manufacturing interview questions  Oracle Apps Manufacturing Interview Questions (51)
 Oracle Apps HRMS interview questions  Oracle Apps HRMS Interview Questions (76)
 Oracle Apps CRM interview questions  Oracle Apps CRM Interview Questions (9)
 Oracle Apps SCM interview questions  Oracle Apps SCM Interview Questions (104)
 Oracle Install Base interview questions  Oracle Install Base Interview Questions (62)
 Oracle Service Contracts interview questions  Oracle Service Contracts Interview Questions (101)
 Oracle Apps AllOther interview questions  Oracle Apps AllOther Interview Questions (11)
Question

How to pass data into EXECUTE_IMMEDIATE statement in plsql 
body ?
 Question Submitted By :: Sumeet.mishra05
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
Answer
# 1
Hope this pice of code explains:

declare
v_query VARCHAR2 (200);
v_employee_name VARCHAR2 (50);
BEGIN
v_query := 'SELECT emp_name from employees where emp_id =
102';
EXECUTE IMMEDIATE v_query
INTO v_employee_name;
DBMS_OUTPUT.put_line ('Emp Name is ' || v_employee_name);
END;
 
Is This Answer Correct ?    10 Yes 1 No
Eldho
 
  Re: How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
Answer
# 2
declare
v_query VARCHAR2 (200);
v_inv_item_id VARCHAR2 (50);
BEGIN
v_query := 'SELECT inventory_item_id from
mtl_onhand_quantities_detail where inventory_item_id =107';
EXECUTE IMMEDIATE v_query
INTO v_inv_item_id;
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
exception
when others then
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
END;
 
Is This Answer Correct ?    4 Yes 1 No
M.n
 
 
 

 
 
 
Other Oracle Apps Technical Interview Questions
 
  Question Asked @ Answers
 
Presently u are working in which version? Accenture 4
Steps for DFF registration IBM 2
How to print multi currency,multi language in xml?   1
what is aim methodolozy Wipro 1
what is difference between procedure and function E-Logic 5
Can u attach Request set with in the Request set? Satyam 2
what is unit of measure classes? give atleast two examples. name the underlying table. Scan-Steel 1
how to create requst set in oracle apps and how to send muliple requests at a time, Genpact 1
how to customize the report,please tell me customization steps Accenture 4
Is PlaceHolderColumn Function or Procedure? Why we don't write any code in that? Oracle 3
How will you get the concurrent program output as email? KPIT 2
how can we get odd numbered pages in output of a report Infosys 2
 
For more Oracle Apps Technical Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com