W3Courses


There are multiple ways to return a column that is not null out of 2, 3 or more columns. The SQL statements that can be used for this purpose are NVL, NVL2, CASE, and COALESCE


CASE function accepts multiple parameters with conditions. If the condition returns true the corresponding value is returned. There are two ways to write the CASE Statements.


IFF(exp1, exp2, expr3) function accepts 3 parameters. If the first parameter is not Null, the function returns the second parameter, otherwise the function returns the third parameter.


NVL2(exp1, exp2, expr3) function accepts 3 parameters. If the first parameter is not Null, the function returns the second parameter, otherwise the function returns the third parameter.


ISNULL(exp1, exp2) function accepts 2 parameters. If the first parameter is not Null, the function returns the first parameter, otherwise the function returns the second parameter.


NVL(exp1, exp2) function accepts 2 parameters. If the first parameter is not Null, the function returns the first parameter, otherwise the function returns the second parameter.


Companies and team use different sequences to identify values to assign to User Stories. These values are called Story Points. Following are four most common sequences I can find


Best practices are key to standardizing processes and forecast accurate outcome to guarantee success.


Following are 10 common mistakes most teams make when using story points. Some of these mistakes come from personal experiences. We all learn from our mistakes, right?


Story Point provide accurate estimates and the flexibility to utilize resources in an efficient way. There are many benefits to using Story Point, out of which top five are mentioned below.

Pages

User login