compare

Syntax

compare varA varB

Description

Compares the values of two variables and reports if they are different. The first difference is reported.

Examples

Command> var a varchar2(10) := 'ABC';
Command> var b varchar2(10) := 'ABC';
Command> var c varchar2(10) := 'ABC1';
Command> compare a a;
Bind variables "A" and "A" match.
Command> compare a b;
Bind variables "A" and "B" match.
Command> compare a c;
Bind variable "A" differs from "C" starting at offset 3.
A    : ABC
C    : ABC1
The command failed.