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

Premium Content: access is limited to Quest Corporate and Professional members.

Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.

RECONNECT 22: Query Manager: Tips and Tricks