0

I tried to extract the row which doesn't have any value in the timestamp column.

select * from user_details where lastlogin_time = null;

raratiru
  • 8,748
  • 4
  • 73
  • 113
Chakravarthi Cc
  • 1
  • 1
  • [To test for nulls, use only the comparison conditions IS NULL and IS NOT NULL.](https://docs.oracle.com/database/122/SQLRF/Nulls.htm#SQLRF30037) – Alex Poole Dec 09 '17 at 10:01
  • 1
    Possible duplicate of [Update columns with Null values](https://stackoverflow.com/questions/3923721/update-columns-with-null-values) – Alex Poole Dec 09 '17 at 10:03

0 Answers0