what isthe difference between SQL View and Query View?
- 4 Answers
- 34685 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / krishna
In Sql view manually write the SQL statement, Query view
use the PS QUERY tool.
| Is This Answer Correct ? | 30 Yes | 7 No |
Answer / reddy
sql view and query view both are database objects,
sql view manually write the query, developer should know the
syntax. query view developed with ps query tool. just drag
drop the fields. no need to learn more about this tool
| Is This Answer Correct ? | 20 Yes | 3 No |
Answer / bharath
SQL View: We can manually write the SQL Statements
Query View: This is selected to define the record
definition as a view that is constructed using the
PeopleSoft Query tool.Before u can create the
view ,PeopleSoft Application Designer prompts you to save
the definition.
| Is This Answer Correct ? | 10 Yes | 6 No |
Answer / nagaraju
sql view and query both are database objects
sql view manually write the query and query view use the
psquery tool,and both are get the data from database
| Is This Answer Correct ? | 3 Yes | 1 No |
Situation: you want to create a prompt table dynamically for a specified field. How would you do that?
What is getlevel0()? What is the use of %subrec and %selectall functions?
How should Web Application Servers be usedwith PeopleTools 8.1x and PeopleTools 8.4?
Can you please explain the difference between temporary table and sql view in peoplesoft?
Explain does peopletools 8.4 support web server load balancing?
How to taken care performance management in people tools?
Explain the field values for tools tables?
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 People Tools available for Integration Broker?
What is maximum dimension of an array?
What is application engine meta data?
Explain what is user profile & security?
PeopleSoft HRMS 
