Home/ Questions/Q 8866
Next
In Process

SIKSHAPATH Latest Questions

MOHITRAJ
  • 0
  • 0
Asked: 2021-11-29T15:44:23+05:30 In:

Write a PL/SQL program to identify whether a character entered by user is letter or digit.

  • 0
  • 0

Write a PL/SQL program to identify whether a character entered by user is letter or digit.

question
Share

    1 Answer

    1. I'M ADMIN
      DECLARE

    get_ctr CHAR(1) := 'B';

BEGIN

    IF ( get_ctr >= 'A'

         AND get_ctr <= 'Z' )

        OR ( get_ctr >= 'a'

             AND get_ctr <= 'z' ) THEN

      dbms_output.Put_line ('The given character is a letter');

    ELSE

      dbms_output.Put_line ('The given character is not a letter');




      IF get_ctr BETWEEN '0' AND '9' THEN

        dbms_output.Put_line ('The given character is a number');

      ELSE

        dbms_output.Put_line ('The given character is not a number');

      END IF;

    END IF;

END; 

/

    Leave an answer

    You must login to add an answer.

    Need An Account,