Answer / sivakumar_yandra

whenever we are passing values to the query at runtime then
it is called dynamic query .

Answer / susi kumar.p [infotech enterpr

Runtime Queries which are creating while at forms , modules
and which may usually be allocated with temporary memory
storeage were called as dynamic queries.

best examples are sql statements which we generally used at
forms and modules.

Note:- Thank You Siva

Answer / manu

Using dynamic queries, you can alter the basic structure of a query when the report is run. For example, you could write an expression that changes the table or fields from which data is retrieved based on the user's locale information.

How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?

0 Answers  

---

What are the three types of anomalies in database and Explain?

9 Answers  

---

Differentiate between delete and truncate table?

0 Answers  

---

sparse lookup and where its options we find in OCI and db2?

0 Answers   TCS,

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

---

---

What is Stored procedure ?

4 Answers   IBM, iGate, Inspira Technologies,

---

How many indexes can be created on a table?

0 Answers   Abacus,

---

Data structure used to implements a menu:

0 Answers   Verifone,

---

Explain about ur projets on teradata???

0 Answers   Wipro,

---

what is vlook up in ms excel and how does it used???

1 Answers   CybAge,

---

What happens when shared and exclusive locks are applied on data item?

0 Answers  

---

define primary key index, bitmap index, hash index,virtual indwx

0 Answers   Cap Gemini,

---