Introduction to Java for PL/SQL Programmers

Java-PL/SQL Comparison

Java Examples:

uThe char datatype can only represent a single character or symbol, and may be initialized as follows:

// decimal equivalent of letter 'a' char myFirstChar = 97;

// using a character
char mySecondChar = 'a';

// octal equivalent of letter 'a' char myThirdChar = '\141';

// Unicode (Hex) value for 'a'

char myFourthChar = '\u0061' ;

PL/SQL Example:

uThe CHAR datatype is a fixed length string.

v_string_char CHAR(48) := 'Datatype CHAR is a fixed length string in PL/SQL';

Char Datatype Examples

Java vs. PL/SQL