查看表结构
desc temp_sap;
Name Type Nullable Default Comments
-------------- -------------- -------- ------- --------
ENTITY_SYSCODE NUMBER
MAWB VARCHAR2(100) Y
TARGET VARCHAR2(20) Y
VALUE VARCHAR2(20) Y
FORWARDER VARCHAR2(20) Y
CHANNEL VARCHAR2(200) Y
RECEIVER VARCHAR2(500) Y
CREATEDATE DATE Y
FINISHDATE DATE Y
PUBLISHDATE DATE Y
CONFIRMDATE DATE Y
JOBSTATUS VARCHAR2(20) Y
JOBCONTENT VARCHAR2(2500) Y
JOBLOG VARCHAR2(20) Y
ENTITY_XML XMLTYPE