what is dynamic view?
- 3 Answers
- 20329 Views
- I also Faced
- E-Mail Answers
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 |
What are the options for using sql in people code?
Explain how to taken care performance management in people tools?
How the output of a sql query be stored in a variable using peoplecode?
What conditions are required to establish parent child relationship between two records?
Does peopletools 8.4 support web server load balancing?
Explain the application package?
Does peoplesoft support the web servers that bea weblogic and ibm websphere can plug into? How?
What is difference between getrowset and createrowset in people code?
Hi I just finished my peoplesoft course recently and am planning to attend an interview next week...i am applying as a fresher...so can u plz help me with some of the important interview questions for a fresher....its urgent...
What are the field values for tools tables?
In case of record level audit what is the structure of table?
For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?
PeopleSoft HRMS 
