update case when oracle的相關文章
update case when oracle的相關商品

Oracle DECODE() and SQL Server’s CASE WHEN | maverick web
瀏覽:1238
日期:2025-04-27
DECODE EXAMPLE: SELECT supplier_code, decode(supplier_id, 10000, 'IBM', 10001, 'Microsoft', 10002, 'Hewlett Packard', 'Gateway') supplier_name FROM suppliers; The DECODE() function accepts a field name to evaluate, then allows you to specify what result ....看更多