ORA-00936:缺少表达式Oracle Apex [英] ORA-00936: missing expression Oracle Apex

问题描述

SELECT crime_name || 'Was Committed On' ||, crime_date, victim.firstname AS "VICTIM" || 'Is The Victim', ||witness.firstname AS "WITNESS" || 'Witnessed The Crime' ||, Suspect.firstname AS "SUSPECT" || 'Is Suspected Of Committing The Crime' || FROM Crime, Victim, Witness, Suspect
WHERE victim.crime_no = crime.crime_no AND witness.crime_no = crime.crime_no AND suspect.crime_no = crime.crime_no;  

有人可以帮助我吗?我不断收到缺少的表达式错误，我似乎无法弄清楚.任何帮助将不胜感激.

Can any one help me? I keep getting the missing expression error, I just cant seem to figure it out. Any help would be appreciated.

我正在使用oracle Apex

I'm using oracle Apex by the way

谢谢！

推荐答案

尝试一下:

SELECT crime_name || ' Was Committed On ' || crime_date, 
       victim.firstname || ' Is The Victim' AS "VICTIM" , 
       witness.firstname || ' Witnessed The Crime'  AS "WITNESS",
       Suspect.firstname || ' Is Suspected Of Committing The Crime' AS "SUSPECT"
FROM   Crime, Victim, Witness, Suspect
WHERE  victim.crime_no = crime.crime_no AND 
       witness.crime_no = crime.crime_no AND 
       suspect.crime_no = crime.crime_no; 

别名必须在最后.

这篇关于ORA-00936:缺少表达式Oracle Apex的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！