Handling NULL value in ORACLE Table Query

Question

I have a question regarding handling NULL value in a column in ORACLE Table.

So, when i query a table, i get this error message in every NULL value occurences

Notice: Undefined index: STATUS in C:\xampp\htdocs\WeltesInformationCenter\AdminLTE\pages\tables\assignmenttable.php on line 481

my query is like this

SELECT MASTER_DRAWING.*, (SELECT PREPACKING_LIST.PACKING_STATUS FROM PREPACKING_LIST WHERE MASTER_DRAWING.HEAD_MARK = PREPACKING_LIST.HEAD_MARK) STATUS FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME

My question is, how to handle NULL value so that when it sees a null value, it can return some value such as 0 or any string.

Thanks

You can use NVL to replace null with another value, but more likely, you have a problem in your PHP code. — Erich Kitzmueller
– Erich Kitzmueller, Commented Sep 10, 2014 at 8:30
@ammoQ i did try this SELECT MASTER_DRAWING.*, (SELECT NVL(PREPACKING_LIST.PACKING_STATUS,'N/A') FROM PREPACKING_LIST WHERE MASTER_DRAWING.HEAD_MARK = PREPACKING_LIST.HEAD_MARK) STATUS FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME But its doesnt work — marmar
– marmar, Commented Sep 10, 2014 at 8:40
try SELECT MASTER_DRAWING.*, NVL((SELECT PREPACKING_LIST.PACKING_STATUS FROM PREPACKING_LIST WHERE MASTER_DRAWING.HEAD_MARK = PREPACKING_LIST.HEAD_MARK),'N/A') STATUS FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME instead — Erich Kitzmueller
– Erich Kitzmueller, Commented Sep 10, 2014 at 8:43
Awesome, post it in an answer so i can rate this a a correct answer — marmar
– marmar, Commented Sep 10, 2014 at 8:52

Erich Kitzmueller · Accepted Answer · 2014-09-10 10:19:14Z

2

Try

SELECT MASTER_DRAWING.*,
   NVL((SELECT PREPACKING_LIST.PACKING_STATUS
      FROM PREPACKING_LIST
      WHERE MASTER_DRAWING.HEAD_MARK = PREPACKING_LIST.HEAD_MARK),'N/A'
   ) STATUS
 FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME

answered Sep 10, 2014 at 10:19

Erich Kitzmueller

37.1k5 gold badges85 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Handling NULL value in ORACLE Table Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related