what is meant by Dynamic query?
Answers were Sorted based on User's Feedback
Answer / sivakumar_yandra
whenever we are passing values to the query at runtime then
it is called dynamic query .
| Is This Answer Correct ? | 30 Yes | 9 No |
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
| Is This Answer Correct ? | 17 Yes | 5 No |
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.
| Is This Answer Correct ? | 3 Yes | 1 No |
What is the concept of Virtual field?
How do you pass parameter in stored procedure?
Explain artificial key?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
Can you tell any two advantages of stored procedures?
What is the purpose of firebase?
write a query for the fifth highest salary?
17 Answers IBM, Matlabs, Ramco,
CLI stands for?
What is Data Modelling?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
In TeraData We have 5 SQL queries, without using BTEQ how can we execute those queries?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)