function sql_Color_AddNew_Rule( pQuestion varchar2, pUser varchar2, pGroup number ) return number is iID number; begin /* -- find new ID */ select nvl( max( c_id ), 0 ) + 1 into iID from factory.an_color where lower( c_question ) = lower( pQuestion ) and lower( c_user ) = lower( pUser ) and c_group = pGroup; ...
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Monday, January 22, 2018
ORACLE - How replace NULL value
nvl() function replace NULL value with second parameter (..in this example 0):
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment