PLSQL | COS Function

PLSQL | CHR Function

Last Updated : 19 Sep, 2019

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or a combination of all. The CHR Function in PLSQL is the opposite of the ASCII function and is used to return the character based on the NUMBER code. Syntax:

CHR( number_code )

Parameters Used: number_code - It is used to retrieve the character for the specified number code. Supported Versions of Oracle/PLSQL:

Oracle 12c
Oracle 11g
Oracle 10g
Oracle 9i
Oracle 8i

Example:

DECLARE 
   Test_Char varchar2(4) := '69';
   Test_Char1 varchar2(4) := '72';
   
   BEGIN 
   dbms_output.put_line(CHR(Test_Char)); 
   dbms_output.put_line(CHR(Test_Char1)); 
    
END;

Output:

E
H

PLSQL | COS Function

S

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

PLSQL | COSH Function

The PLSQL COSH function is used to return the hyperbolic cosine of a numeric value. The COSH function accepts one parameter which is the number whose hyperbolic cosine needs to be calculated. The COSH function returns a value of the numeric data type. This function takes as an argument any numeric d

PLSQL | COS Function

The PLSQL COS function is used to return the cosine of a numeric value. The COS function accepts one parameter which is the number whose cosine needs to be calculated. The COS function returns a value of the numeric data type. This function takes as an argument any numeric data type as well as any n

PLSQL | CEIL Function

The CEIL is an inbuilt function in PLSQL which is used to return the smallest integer value which is either greater than or equal to the given input number. This input number might be in the fraction or in the whole number. Syntax: CEIL(number) Parameters Used: Here the parameter number is the input

PLSQL | ACOS Function

The PLSQL ACOS function is used to return the arc cosine of a number. The ACOS function only one parameter which is a number and the argument number must be in the range of -1 to 1, and the function returns a value in the range of 0 to pi, expressed in radians. This function takes as an argument any

PLSQL | CONVERT Function

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or a combination of all. The CONVERT function in PLSQL is used to convert a string from one character set to another. Generally, the dest

PLSQL | ASCII Function

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or a combination of all. The ASCII Function in PLSQL is used to return the NUMBER code that represents the specified character. Syntax AS

PLSQL | FLOOR Function

The FLOOR is an inbuilt function in PLSQL which is used to return the largest integer value which will be either equal to or less than from a given input number. Syntax: FLOOR(number) Parameters Used: This function accepts a parameter number which is the input number on which FLOOR function is calle

PLSQL | ASCIISTR Function

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or a combination of all. The ASCIISTR Function in PLSQL is used for converting a string in any character set to an ASCII string using the

PLSQL | ABS Function

The PLSQL ABS function is used for returning the absolute value of a number. Absolute value is used for depicting the distance of a number on the number line from 0. The direction of the number from zero is not considered since the absolute value of a number is never negative. The ABS in PLSQL funct

PL/SQL Functions

PL/SQL functions are reusable blocks of code that can be used to perform specific tasks. They are similar to procedures but must always return a value. A function in PL/SQL contains:Function Header: The function header includes the function name and an optional parameter list. It is the first part o