2.308 PLSQL_IMPLICIT_CONVERSION_BOOL
PLSQL_IMPLICIT_CONVERSION_BOOL
allows or disallows implicit conversions in PL/SQL between numeric data types and the BOOLEAN
data type, and between character data types and the BOOLEAN
data type.
Property | Description |
---|---|
Parameter type |
Boolean |
Default value |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
|
Basic |
No |
When this parameter is set to true
, PL/SQL supports the following implicit data type conversions:
-
Numeric data type to
BOOLEAN
data type-
Non-zero numeric values are implicitly converted to the
BOOLEAN
valueTRUE
-
The numeric value of
0
is implicitly converted to theBOOLEAN
valueFALSE
-
-
Character data type to
BOOLEAN
data type-
Character values such as
'true'
,'t'
,'yes'
,'y'
,'1'
, and'on'
(case-insensitive) are implicitly converted to theBOOLEAN
valueTRUE
-
Character values such as
'false'
,'f'
,'no'
,'n'
,'0'
, and'off'
(case-insensitive) are implicitly converted to theBOOLEAN
valueFALSE
-
-
BOOLEAN
data type to numeric data type-
The
BOOLEAN
valueTRUE
is implicitly converted to the numeric value1
-
The
BOOLEAN
valueFALSE
is implicitly converted to the numeric value0
-
-
BOOLEAN
data type to character data type-
The
BOOLEAN
valueTRUE
is implicitly converted to the character value'TRUE'
-
The
BOOLEAN
valueFALSE
is implicitly converted to the character value'FALSE'
-
When this parameter is set to false
, PL/SQL does not support such implicit conversions.
Note:
This parameter is available starting with Oracle Database 23ai.