From 123-CBT Computer Based Training
Oracle Form Builder R6 Controlling the User Interface Programmatically 

... manage the data in record groups. Define a query record group by using built-ins. Define a non-query record group by using built-ins. Match the built-ins used to process record group rows with their functionality. Write the code to manipulate record group rows by using built-ins. Write the code to manipulate selected record group rows by using built-ins. Identify the built-ins used for
more...
Oracle Form Builder Handling Multiple Object Relationships 

...o search for record group objects. Define a query record group by using built-ins. Define a non-query record group by using built-ins. Write the code to manipulate record group rows by using built-ins. Write the code to manipulate selected record group rows by using built-ins. Identify the built-ins used for manipulating list items. Write the code to implement dynamic list item by using
more...
NetWare and Windows NT Integration - Part 3 

...r object.
Configure user membership to a
Windows NT user group by using the
NDS user object.
Create a Windows NT user account that has access to a Windows NT domain by using
User Manager for
Domains.
Delete a Windows NT user account by using User Manager for Domains.
Synchronize the Windows NT and NDS passwords of a user by using NetWare Administrator.
Synchronize the Windows NT and NDS
more...
SQL Server 7 0 Designing and Implementing Data Warehouses - Part 4 

...gation functions. Group the aggregated data by using the
GROUP BY keyword. Retrieve specific groups of the aggregated data by using the
HAVING keyword. Calculate totals and subtotals of the groups in the aggregated data by using the
ROLLUP keyword. Calculate totals and subtotals for all combination of values in the aggregated data by using the
CUBE keyword. Access data from multiple tables
more...
SQL Server 7 0 - Implementing a Database - Part 4 

...ns handle null values. Select statements to use with the
GROUP BY clause on columns. Select statements to use with the GROUP BY clause on expressions. Select when to use the
HAVING clause. Perform the steps to summarize group values. Perform the steps to summarize combinations of groups. Select the characteristics of the
GROUPING function. Select guidelines for using the
COMPUTE clause.
more...
SQL and PL SQL Data Retrieval Techniques 

...mmon group functions. Group rows retrieved by using the
GROUP BY clause. Write single-row, multiple row, multiple-column subqueries. Obtain values at run time by creating and maintaining substitution variables. Use
SQL*Plus format commands to format report output. Run a formatted report using a SQL*Plus script file. C ontent
Emphasis Skills-Based A udience
Application more...
Oracle SQL for End Users--Part 2 

...ons in a query. Return the number of rows in a specified group by using the
COUNT group function in a query. Manage null values when using group functions in a
SQL statement. Group rows retrieved by using the
GROUP BY clause. Identify illegal queries involving group functions. Unit 3:
Subqueries Duration: 2 Hour(s) Identify the proper syntax when using a subquery in a SQL
more...