Home / Educational Content / PeopleSoft / RECONNECT 22: Query Manager: Tips and Tricks

RECONNECT 22: Query Manager: Tips and Tricks

Presented at RECONNECT 22
Session ID: 100470

If you’re a technical or functional user that is looking to learn some tips and tricks of Query Manager, this session is for you. If you are confident in your ability to write queries to retrieve transactional information about student/employee/vendor/supplier; and are looking for ways to be more sophisticated in your data retrieval, then this is the session is also for you!

We will begin with some basic tips and tricks for query writing, and then move to some more complicated topics, like creating smart prompts, or using expressions wisely. Finally, we discuss some advanced topics such as query administration, using query manager on 4-tier vs using query builder tool within Application Designer, look at the new classic-plus view of query manager and some tips/tricks.

Topics Covered will include:
1. Understanding Joins
2. Manipulating Data with Expressions
3. Aggregating Data
4. Sub Queries
5. Tips and Tricks
6. New Query Technology & Features
7. Query Tool within Application Designer (Tools 8.57)
8. Query Administration

Watch the full-length video

You’ve reached the ultimate Oracle customer network—exclusively for Quest Corporate and Professional members.

Join Quest to unlock access to strategic content centers, event replays, exclusive programming, and expert insights—all designed to help Oracle users like you go further, faster.

Whether you're on JD Edwards, PeopleSoft, or Oracle Cloud, Quest connects you with a powerful peer network and Oracle experts so you can make smarter decisions, drive innovation, and get more from your investment.

Quest is where Oracle customers connect, learn, and lead with confidence. Ready to join them?

RECONNECT 22: Query Manager: Tips and Tricks