-
ora 932, cant display the select column
SVRMGR> desc sapr3.dbtablog;
Column Name Null? Type
------------------------------ -------- ----
LOGDATE NOT NULL VARCHAR2(8)
LOGTIME NOT NULL VARCHAR2(6)
LOGID NOT NULL VARCHAR2(18)
TABNAME NOT NULL VARCHAR2(30)
LOGKEY NOT NULL VARCHAR2(250)
HOSTNAME NOT NULL VARCHAR2(20)
USERNAME NOT NULL VARCHAR2(12)
TCODE NOT NULL VARCHAR2(20)
PROGNAME NOT NULL VARCHAR2(40)
OPTYPE NOT NULL VARCHAR2(1)
DATALN NOT NULL NUMBER(5)
LOGDATA LONG RAW
SVRMGR> select * from sapr3.dbtablog where tabname like '%T028%';
ORA-00932: inconsistent datatypes
however, if i specify column instead of a *, there is no error of 932. Please advise.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|