mirror of
https://github.com/semver/semver.git
synced 2026-07-11 05:33:07 -05:00
When formatting, nvl will automatically add spaces #451
No Assignees
Notifications
Due Date
No due date set.
Dependencies
No dependencies set.
Reference: github-starred/semver#451
Reference in New Issue
Block a user
Delete Branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @louqiang on GitHub (Jan 21, 2021).
Enter SQL：
select b.company_no,
b.phone_no_2
from temp_tb_dwd_cu_912688web_company_basic_s_4 b
where nvl(phone_no_2,'') <> '';
Output SQL：
SELECT b.company_no, b.phone_no_2
FROM temp_tb_dwd_cu_912688web_company_basic_s_4 b
WHERE NVL (phone_no_2, '') <> '';