null vs empty string in Oracle [duplicate]

by

This is because Oracle internally changes empty string to NULL values. Oracle simply won’t let insert an empty string.

On the other hand, SQL Server would let you do what you are trying to achieve.

There are 2 workarounds here:

  1. Use another column that states whether the ‘description’ field is valid or not
  2. Use some dummy value for the ‘description’ field where you want it to store empty string. (i.e. set the field to be ‘stackoverflowrocks’ assuming your real data will never encounter such a description value)

Both are, of course, stupid workarounds 🙂

More Related Contents:

  1. Why does Oracle 9i treat an empty string as NULL?
  2. Convert timestamp datatype into unix timestamp Oracle
  3. check if “it’s a number” function in Oracle
  4. how to replace multiple strings together in Oracle
  5. Trigger to enforce M-M relationship
  6. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  7. Why are Oracle table/column/index names limited to 30 characters?
  8. Is it possible to kill a single query in oracle without killing the session?
  9. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  10. How to View Oracle Stored Procedure using SQLPlus?
  11. Merging two tables in SQL [closed]
  12. How to uninstall / completely remove Oracle 11g (client)?
  13. Get counts of all tables in a schema
  14. Determining location of relevant tnsnames.ora file
  15. Default row ordering for select query in oracle
  16. Does std::string have a null terminator?
  17. Oracle trigger after insert or delete
  18. Difference between a user and a schema in Oracle?
  19. Base64 encoding and decoding in oracle
  20. Auto-increment in Oracle without using a trigger
  21. How to send email using Oracle 10 g Forms
  22. How to get primary key column in Oracle?
  23. How to create a user in Oracle 11g and grant permissions
  24. How to count the number of occurrences of a character in an Oracle varchar value?
  25. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  26. Oracle Parameters with IN statement?
  27. Valid Date Checks in Oracle
  28. string.Empty vs null.Which one do you use?
  29. How to generate a GUID in Oracle?
  30. Escaping single quote in PLSQL

Leave a Comment