Representation of Null in Toad. Toad shows different results.
STEPS:
1)
Go to View menu | Toad Options | Data Grids | Visual | “Null column text:” | type “NULLs” click Apply and OK. Then close and re-open the Editor Window.
2)
ALTER SESSION SET CURRENT_SCHEMA = Marvin1;
DROP TABLE NULL_TEST2;
CREATE TABLE NULL_TEST2 (COL1 CHAR (1));
INSERT INTO NULL_TEST2 (col1) VALUES (' ');
INSERT INTO NULL_TEST2 (col1) VALUES (NULL);
INSERT INTO NULL_TEST2 (col1) VALUES (1);
COMMIT;
SELECT * FROM NULL_TEST2;
Run the above script using F5.
The first two rows of the results above are just ‘blank’.
3)
Click on Grid 1, and the two rows shows as “NULLs”, like how it is set in the Toad Options.
It is not the same as the previous run above where it’s all ‘blank’?
4)
un the “SELECT * FROM Marvin1.NULL_TEST2;” using F9. Now one row shows as ‘blank’, and the other shows as “NULLs”.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center