by T.R. Bharath Rajkumar – One common requirement when writing queries is to do a range comparison in DECODE. But DECODE allows only exact comparison. Range comparison can be achieved by making use of the function SIGN in DECODE.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help