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

CTE Resource Center - Verso

Virginia’s CTE Resource Center

Describe the use of conversion functions.

Definition

Description of conversion functions (converting data from one type to another) should include actual queries showing the conversion of

  • character data to numbers
  • characters to dates
  • numbers to characters
  • dates to characters. 

Conversions that will not result in a loss of data or precision may be completed implicitly, or without specific code performing the conversion. Explicit conversions must be hard-coded to be executable by the processor if the loss of data or precision is possible. Specific functions include

  • TO_NUMBER
  • TO_DATE
  • TO_CHAR.

Conversion functions of dates also include format models that lay out a template for date and number conversions.  

Conversions functions also include the NVL function that converts nulls to actual values, which can then be manipulated with numeric functions. 

Description should also illustrate complex transformation of data by including queries where functions are nested within each other.

Related Standards of Learning

English

10.5

The student will read, interpret, analyze, and evaluate nonfiction texts.
  1. Analyze text features and organizational patterns to evaluate the meaning of texts.
  2. Recognize an author’s intended audience and purpose for writing.
  3. Skim materials to develop an overview and locate information.
  4. Compare and contrast informational texts for intent and content.
  5. Interpret and use data and information in maps, charts, graphs, timelines, tables, and diagrams.
  6. Draw conclusions and make inferences on explicit and implied information using textual support as evidence.
  7. Analyze and synthesize information in order to solve problems, answer questions, and generate new knowledge.
  8. Analyze ideas within and between selections providing textual evidence.
  9. Summarize, paraphrase, and synthesize ideas, while maintaining meaning and a logical sequence of events, within and between texts.
  10. Use reading strategies throughout the reading process to monitor comprehension.

11.5

The student will read, interpret, analyze, and evaluate a variety of nonfiction texts including employment documents and technical writing.
  1. Apply information from texts to clarify understanding of concepts.
  2. Read and correctly interpret an application for employment, workplace documents, or an application for college admission.
  3. Analyze technical writing for clarity.
  4. Paraphrase and synthesize ideas within and between texts.
  5. Draw conclusions and make inferences on explicit and implied information using textual support.
  6. Analyze multiple texts addressing the same topic to determine how authors reach similar or different conclusions.
  7. Analyze false premises, claims, counterclaims, and other evidence in persuasive writing.
  8. Recognize and analyze use of ambiguity, contradiction, paradox, irony, sarcasm, overstatement, and understatement in text.
  9. Generate and respond logically to literal, inferential, evaluative, synthesizing, and critical thinking questions about the text(s).