Hi Gurus,
I have one table created dynamically in one shell script.
Actual query has lots of columns selected from real tables.
There are few columns which are created like below (0 as id , 'ABC...Z' AS Value etc), which we populate later.
When you describe this table it is :
ID NUMBER
VALUE CHAR(26 BYTE)
However, when you insert into this table, even if 'value' is <26 bytes, it shows length as 26 bytes.
This creates issue during UNION where I am expecting distinct.Any idea if there is any way we can resolve this issue?
CREATE TABLE TEST
AS (
SELECT
0 AS ID,
'ABCDEFGHIJKLMNOPQRSTUVQZYZ' AS VALUE
FROM DUAL S
WHERE 1 = 0);
insert into test values(1,'abc');
select length(id), length(VALUE) from Test;