Answer / hitendra yadav

DTS is (Data Transformation Services)- which is the wizard
or fuctionality in SQL Server for transfer data from one
database to other database for example load data from EXCEL
SHEET to oracle database or SQL Server database,means it is
basiclly used to transfer data.

 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,

---

create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......

1 Answers   HCL,

---

How to use "out" parameter properly?

0 Answers  

---

1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]

2 Answers  

---

How do you handle duplicate records in a database?

1 Answers  

---

What is meant by joins? List out the types of joins.

0 Answers  

---

What is the use of Redo Log Information ?

2 Answers  

---

List the various oracle database objects?

0 Answers  

---

i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?

2 Answers   Microsoft,

---

How do I call oracle stored procedures that take no parameters?

0 Answers  

---

How do I spool to a csv formatted file using sqlplus?

0 Answers  

---

what are corelated subqueries

1 Answers   Global Infotech,

---