select decode (' 2 ', 
1, 
NVL (a.c urr_ks, 'unknown departments') | |' - '| | NVL (a.y s_code,' unknown doctors'), 
2, 
NVL (a.c urr_ks, 'unknown department), 
3, 
NVL (a.z x_ks, 'unknown department), 
4, 
NVL (a.c urr_ks, 'unknown departments') | |' - '| | NVL (a.z zys,' unknown doctors')) KSDM, 
A.f ygl SFXM, 
The sum (a. e * b.j ylx) fyhj, 
The sum (round (a. e * NVL (a.s elf_percent, 1), 2) * b.j ylx) zfje, 
The sum ((a. e - a.r lje) * b.j ylx) sjfyhj, 
The sum (round ((a. e - a.r lje) * NVL (a.s elf_percent, 1), 2) * b.j ylx) sjzfje 
The from zy_total_fee b, zy_detail_charge a 
Where Amy polumbo atient_no=p. atient_no 
And a. LXH between b. y_jlxh1 and b. y_jlxh2 
And (((b.j z_date between 
(to_date (' 2015/06/01 00:00:00 ', 'yyyy/MM/dd hh24: mi: ss')) and 
(to_date (' 2015/06/30 23:59:59 ', 'yyyy/MM/dd hh24: mi: ss'))) and 
'1'=1) or 
((b.r b_date between 
(to_date (' 2015/06/01 00:00:00 ', 'yyyy/MM/dd hh24: mi: ss')) and 
(to_date (' 2015/06/30 23:59:59 ', 'yyyy/MM/dd hh24: mi: ss'))) and 
'1'=2 and b.r b_date is not null)) 
And (instr (' * ', '^ ^' | | b.b RXZ | | '^ ^') & gt; 0 or '*'='*') 
And ((' 1 '=1) or (' 1' & lt;> 1 and b. ybh='1')) 
Group by decode (' 2 ', 
1, 
NVL (a.c urr_ks, 'unknown departments') | |' - '| | NVL (a.y s_code,' unknown doctors'), 
2, 
NVL (a.c urr_ks, 'unknown department), 
3, 
NVL (a.z x_ks, 'unknown department), 
4, 
NVL (a.c urr_ks, 'unknown departments') | |' - '| | NVL (a.z zys,' unknown doctors')), 
A.f ygl 

CodePudding user response:

Debugged, seeing in vs the final execution of SQL is what, is does not have a problem

CodePudding user response:

In vs breakpoint debugging, you this statement should be in vs patchwork,

CodePudding user response:

Should be spell VS the SQL statement is wrong,

CodePudding user response:

After breaking point under debugging, will run the SQL to perform in PLSQL, reading the newspaper what's wrong, find a wrong again wrong place in the VS change, estimation is spliced didn't spell well, take a closer look at

CodePudding user response:

SQL string with @, breakpoint debugging it

CodePudding user response:

Can be in all the SQL statements, plus a select * from ()