what is dynamic view?
Answers were Sorted based on User's Feedback
Answer / kiran
Dynamic view that can be used like a view in pages and
PeopleCode, but is not actually stored as a SQL view in the
database. Instead, the system uses the view text as a base
for the SQL Select that is performed at runtime. Dynamic
views can provide superior performance in some situations,
such as search records and in PeopleCode Selects, because
they are optimized more efficiently than normal SQL views.
| Is This Answer Correct ? | 24 Yes | 2 No |
Answer / krishna
Dynamic View is similar to SQL View but we can not build
the dynamic view. When we dont want store the data base
then us dynamic view.
| Is This Answer Correct ? | 19 Yes | 9 No |
Answer / venkat
BY USING DYNAMIC VIEW WE CAN CHANGE OUR SQL QUERY
DYNAMICALLY AT RUNTIME BY USING SQLTEXT PROPERTY.SO WE CAN
GET DYNAMIC RESULTS ACCORDING TO OUR REQUIREMENT.
BUT IN SQL VIEW WE CAN NOT CHANGE THE SQL QUERY ONCE SAVED.
SO WE CAN GET STATIC RESULTS WHEN USING SQL VIEWS.
| Is This Answer Correct ? | 12 Yes | 2 No |
Tell me the use of set control field in record field properties?
Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work with my other corporate web servers and tools?
What are query tables?
How to give access to the records that are to be used in a query?
What is page meta data?
You want to migrate database from one database to another. How would you do that?
What is an expert entry?
What is xlat - translate values?
You want to create a prompt table dynamically for a specified field. How would you do that?
How can you improve the security and usability of a prompt table edit?
Explain what is project meta data?
Can a PeopleTools 8.4 and a PeopleTools 8.1x application server run on the same machine?