I want to generate an output with blank/empty column with a "Select" query in oracle. I'm able to achieve this with below sql query:
SELECT CustomerName AS Customer, "" AS Contact
FROM Customers;
So when I run above sql query it returns a table with two columns "Customer" column with content in it and "Contact" column with no content or blank column. I want to achieve same with oracle query. Any help will be highly appreciated.
I think you should use null
SELECT CustomerName AS Customer, null AS Contact
FROM Customers;
And Remember that Oracle
treats a character value with a length of zero as null.
SELECT CustomerName Customer, NVL('',' ') Contact FROM Customers . Here it is replacing the null values with empty space.In DB2, using single quotes instead of your double quotes will work. So that could translate the same in Oracle..
SELECT CustomerName AS Customer, '' AS Contact
FROM Customers;
I guess you will get ORA-01741: illegal zero-length identifier if you use the following
SELECT "" AS Contact FROM Customers;
And if you use the following 2 statements, you will be getting the same null value populated in the column.
SELECT '' AS Contact FROM Customers; OR SELECT null AS Contact FROM Customers;
"" AS Contactwould be'' AS ContactNote also, in Oracle,NULLand the empty string''are the same thing.'' AS Contactas you suggested in sql developer tool but I is generating (null) in each row of Contact column. My requirement is to generate blank/empty rows in Contact column. FYI, if I run"" AS Contactquery on H2 database it is generating blank/empty rows. Actually my requirement is to convert already existing sql query on H2 database to Oracle database.