Database Administration (MOSC)

MOSC Banner

Query returning wrong result

edited Oct 22, 2013 1:09AM in Database Administration (MOSC) 8 commentsAnswered ✓
Hi Team,

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")

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center