Collections:
Argument Type Auto-Conversion
What Is Argument Type Auto-Conversion?
✍: FYIcenter.com
Argument Type Auto-Conversion is a process that automatically
convert an actual argument into the type expected by the function.
For example, CHAR() expects a list of integers as arguments. If non-integers are provided, they will be automatically converted into integers. For example:
SELECT CHAR(70, '89', 73.1, 98.9, 1.01E2, '110th Street', 116, 101, 114); -- +-------------------------------------------------------------------+ -- | CHAR(70, '89', 73.1, 98.9, 1.01E2, '110th Street', 116, 101, 114) | -- +-------------------------------------------------------------------+ -- | FYIcenter | -- +-------------------------------------------------------------------+
⇐ Variable Number of Arguments
2023-11-15, 2206🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...