Recursive Functions in PL/SQL

1.	Recursive Functions in PL/SQL
Answer» To RETURN the ASCII value of a character, you need to USE the ASCII() method. It RETURNS a numeric value, which is the ASCII value. The following is the syntax: ASCII(myCharacter) Here, myCharacter is the character you need to MENTION to get the ASCICC value. The following is an example: DECLARE a varchar(1) := 'B'; BEGIN dbms_output.put_line(ASCII(a)); END; / The output: 66

Answer»

To RETURN the ASCII value of a character, you need to USE the ASCII() method. It RETURNS a numeric value, which is the ASCII value.

The following is the syntax:

ASCII(myCharacter)

Here, myCharacter is the character you need to MENTION to get the ASCICC value.

The following is an example:

DECLARE a varchar(1) := 'B'; BEGIN dbms_output.put_line(ASCII(a)); END; /

The output:

Discussion