Multiple choice

Which datatype is assigned to a SQL*Plus variable when created with a DEFINE command?

  1. CHAR

  2. DATE

  3. NUMBER

  4. VARCHAR2
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

When you create a variable using the DEFINE command in SQL*Plus, it is always assigned the CHAR datatype by default. DEFINE variables are substitution variables that store text strings and are replaced with their values before SQL statement execution.

Keep practicing — related questions