ZDIA of empty table SQL operations as follows:

Insert into ZDIA select substr (FSRQ, 1, 4) | | '-' | | substr (FSRQ, 5, 2) | | '-' | | substr (FSRQ, 7, 2) the as QRZD, 'SUM' as YZYJ, '000000' as HPC, '0'
As ZBDJ, case when HEY (in '0', '2') then YE * (1) else YE end as YE, 0 as the EFS, 0 as DEFS the from RAW_ZDIA where FSRQ='20191202' and DWHM='1003' order by SJYJ;
Results show that the success and the number of records, but the query ZDIA table is empty, great god what reason is this excuse me

CodePudding user response:

You don't have to submit? Or a string of libraries

CodePudding user response:

reference 1st floor yoyohey response:

you are not committed? Or string library

Behind is the same as the commit, string table is what meaning, can say

CodePudding user response:

You are in the insert statement in the same session query schema of the table to try

CodePudding user response:

 - use this statement check, ZDIA is temporary table, 

The select table_name, tablespace_name, temporary 
The from user_tables where table_name='ZDIA 

CodePudding user response:

To perform the insert statement, need to click the commit to submit, to check the data