Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to pass data into EXECUTE_IMMEDIATE statement in plsql
body ?

Answer Posted / eldho

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 ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are the tables of auto invoice?

1131


Do you know what is applysys in oracle application database schema, what is apps?

1167


What are the Standard Reports and Forms in HRMS?

2287


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2092


What is sca and how is it useful?

1106


pls send me out bound code of supplers,site,bankiformation code pls as soon as

2243


What are the different components you should consider while defining a responsibility in oracle apps?

1057


testing tools?

2223


What is count(*) from po_vendors(any table)?

1073


tell me the scenarios of the independent in reports

2608


What are the benefits of using soa architecture?

1227


What do you understand by a set of books?

1098


how can develope the po variance and po summary report? with tables mandatory columns and query please?

2363


How do you register report in oracle apps?

1080


CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2609