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

testing tools?

2254


What is the concept of soa governance?

1254


where to define interorganization transaction charges and what are the different options?

2421


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

1080


Plz anybody send me Technical specification for AP Interface

2564


what are the prerequisites for costing transactions?

3144


how to print multi lay outs,muti currency,muti language in xml publisher

12289


Tell me how to debug the report?

1125


How do you register report in oracle apps?

1099


What do you understand by concurrent programs?

1101


Can we create tables in apps schema?

1143


Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?

1067


Explain what are the tables of auto invoice?

1142


tell my any difficult situtation you solved in your experience in your company?

2319


how do you describe O2C along with tables

2773