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.

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.

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.

Which peopletool is used to input peoplecode?

1 Answers  

---

Explain what is peoplecode meta data?

1 Answers  

---

What is user profile & security?

1 Answers  

---

What are the different ways we can set up the portal security to access component in portal?

1 Answers  

---

What is difference between getrowset and createrowset in people code?

1 Answers  

---

How to taken care performance management in people tools?

1 Answers  

---

What is the difference between key and alternate search key?

1 Answers  

---

You want to migrate database from one database to another. How would you do that?

1 Answers  

---

Why do peoplesoft often use views as search records?

1 Answers  

---

Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?

2 Answers  

---

Explain what is file layout definitions?

1 Answers  

---

What types of audits are supported by people soft? In case of record level audit what is the structure of table?

1 Answers  

---