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|
Is redis in memory database?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What are the differences between Database Trigger and Integrity constraints ?
Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?
What is the importance of database partitioning?
What do you mean by cluster and non cluster index?
How do database connections work?
what is difference between delete and truncet ?
What is a trace file?
Explain various types of locks in a transaction? Which is better and why?
What are the most common databases?
When should you not use firebase?