[ACCEPTED]-SQL select statement that shows non-existant column?-select
select c1, c2, c3, null as c4 from table;
This would work in Oracle, haven't tried 1 in anything else:
select null thiscolumnisempty, id,id2,id3 from table
select c1, c2, c3, '' as c4 from table; select 3 c1, c2, c3, 0 as c4 from table; if you want 2 int then take 0 or if you want varchar then 1 take ''.
More Related questions