|
Training Classes
| Learning and Development Resources
| Training Directory
| New Training Programs
| New Training Providers
| Site Map
| Promote Training
|
Training Keywords
| Training Programs
| Training Providers
| Regions
|
| Advertise Training Programs
| Login
|
||||||||||||||||||||||
Related Searches :
Substitution Variables Training Programs
From Serebra Learning Corporation
Introduction to PL SQL
 To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL Database administrators, application developers, and database operators more...Introduction to Oracle and SQL in Oracle Database 10g
To introduce Oracle as a relational database management system (RDBMS) and to demonstrate how to use basic SQL statements Database administrators, application developers, and database operators more...Oracle SQL for End Users Part 2
This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers more...
From 123-CBT Computer Based Training
Oracle9i SQL Data Retrieval Techniques
 ...f a SELECT statement. o Identify the characteristics of substitution variables. o Prompt the user for a number value at run time by using a substitution variable. o Prompt the user for a character value at run time by using a substitution variable. Audience The audience includes database administrators, designers, developers, technical support professionals, and application more...Oracle Database 10g PL SQL Fundamentals Part 1
...entify features of bind variables.
Identify features of substitution variables.
Identify the syntax of the %ROWTYPE attribute.
Identify the syntax for creating a PL/SQL record.
Identify the syntax for creating a PL/SQL collection.
Identify guidelines for programming in PL/SQL.
Identify features of PL/SQL functions.
Identify features of nested blocks.
Identify uses of PL/SQL more...Oracle Database 10g SQL Fundamentals I Part 1
...t set of a query by using the ORDER BY clause.
Identify substitution variables that are used while retrieving data by using SQL statements.
Unit 3: SQL Functions
Identify features of single-row functions.
Match the character functions with their uses.
Match the number functions with their purpose.
Identify features of the date functions.
Identify features the functions used more...Oracle SQL and SQL Plus SQL Plus and Reporting
...isplay the text of a command before and after it replaces substitution variables with values.
Complete the SELECT statement that reuses a substitution variable value without prompting the user each time by using the && variables.
Write the SQL*Plus statement to specify a user variable and assign it a CHAR value by using the DEFINE command.
Write the SQL*Plus statement that displays a more...SQL and PL SQL Data Retrieval Techniques
.... 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 developers, database administrators, designer/developers, and technical support professionals. Prior to taking this course, participants more...Oracle SQL for End Users--Part 2
...Finally, the learner creates interactive reports by using substitution variables, and executes a formatted report by using SQL*Plus commands. L earn To: Access data from more than one table by using equijoins and nonequijoins and join a table to itself by using a self join. Group data by using group functions. Embed single-row and multiple-row subqueries in a SQL statement. more...
| ||||||||||||||||||||||
|
| ||||||||||||||||||||||
| Training Directory | New Training Programs | New Training Providers | | Site Map | Promote Training | Login | Links | ||
|
| ||
| Training-Classes.com by Skillbox® 05/03/08 Copyright 1998-2008 skillbox, inc. All rights reserved |
 |
|