Query returning wrong result
In Development environment the below query is fine , please notice spaces between 168 & A in output,
where as I face Issue with same query when running the same query in System Test , please notice spaces between 168 & A in output.
Please see below details and suggest what I have to do now?
OS: HP-Unix
DB Version: 11.2.0.3
Environment: Development
CREATE TABLE "ORACLE"."SMLSCLADJ"
(
"SSC_CODE" NUMBER(3,0) NOT NULL ENABLE,
"UPD_STMP_ACT" CHAR(1) DEFAULT ' ' NOT NULL ENABLE,
"UPD_STMP_DTTM" DATE DEFAULT sysdate NOT NULL ENABLE,
"UPD_STMP_ID" CHAR(8) DEFAULT ' ' NOT NULL ENABLE,
CONSTRAINT "PK_SMLSCLADJ" PRIMARY KEY ("SSC_CODE")