09-11-2007
|
| Administrator
Join Date: Jun 2007
Posts: 3,729
BRL$: 34,845.15 Thanks: 0
Thanked 7 Times in 7 Posts
Rep Power: 405 | |  DECODE or NVL
Hi Tom, The question is whether to use a DECODE or NVL to cmpare a null value. Foe ex : declare name varchar2(10); begin Update emp set emp_name= nvl(name,emp_name); end; I ran the above query with sql_trace and a...
To view links or images in this forum your post count must be 1 or greater. You currently have 0 posts.
| |
__________________
█ High Quality
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█ Powerful
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
█
To view links or images in signatures your post count must be 0 or greater. You currently have 0 posts.
To receive latest updates about BRL Forums, Subscribe to Latest Updates Thread.
| | | |
