what is dynamic view?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What conditions are required to establish parent child relationship between two records?

713


What is differed processing and its advantages?

580


Explain what is record meta data?

538


Tell me how many sub pages, secondary pages can you create in one level?

504


Explain what is portal (structure and content)?

703






What will be the output of an application engine to use component variables instead of state record?

471


How to give access to the records that are to be used in a query?

525


Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?

508


Does peoplesoft support the web servers that bea weblogic and ibm websphere can plug into? How?

472


Which records can be included into a record group?

525


What is difference between getrowset and createrowset in people code?

1090


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

509


What types of audits are supported by people soft?

555


How can you improve the security and usability of a prompt table edit?

533


What is an expert entry?

567