The below query gives error, could anybody throw some idea how to do it?
select NVL(T.VALUE,(SELECT COL_VALUE FROM MASTER_TABLE WHERE NAME= 'DEFAULT_VALUE') ) from TABLE2 T ;
Getting below error.
Error while compiling statement: FAILED: ParseException line 1:30 cannot recognize input near 'SELECT'
Hey @Mano. I understand the frustration of waiting for an answer. Please keep in mind that this is a peer to peer forum at this time. Clouderans do reply when time allows but it is not their primary function. I'd be happy to discuss your experience further via private message if you would like.