# CTE Resource Center - Verso - Database Design and Management (Oracle) Task 1685818548

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Demonstrate the use of character, number, and date functions in SELECT statements.

Definition

Demonstration of character functions should include the following:

  • UPPER
  • LOWER
  • INITCAP
  • CONCAT
  • SUBSTR
  • LENGTH
  • INSTR
  • LPAD
  • TRIM
  • CONCAT
  • LENGTH

Demonstration of numeric functions (performing operations on numeric data) should include the following:

  • ROUND
  • TRUNC
  • MOD

Demonstration of date functions (performing operations on date data) should include the following:

  • SYSDATE
  • +
  • -
  • /
  • *
  • MONTHS_BETWEEN
  • ADD_MONTHS
  • NEXT_DAY
  • LAST_DAY
  • ROUND
  • TRUNC

Related Standards of Learning

Mathematics

COM.7

The student will select and call library functions to process data, as appropriate.

COM.8

The student will implement conditional statements that include “if/then” statements, “if/then/else” statements, case statements, and Boolean logic.

Other Related Standards

Microsoft Imagine Academy Resources

[3.175] SQL Server 2008 Release 2: Querying and Filtering Data in Microsoft SQL Server 2008—E-Learning Module 1

[4.020] Access 2010: Creating Forms—Lesson 4

[5.036] Access 2010: Project 4

NBEA Achievement Standards for Information Technology

Extract useful information using search queries.