Wednesday, 15 May 2013

mysql - Query cannot be parsed, please check the syntax of your query. (ORA-00905: missing keyword) -


is trying to create an interactive report with the SQL query below. The error mentioned in the title is

Choose FIRST_NAME || '' || Where "user name" from users (where user name temp_amal from user ACCESS_DATE & gt accessed_by selection select USERNAME; = P2610_DATE_FROM and ACCESS_DATE & lt; = P2610_DATE_TO and (case: P2610_RADIO) 'Then Col1 =' F 'end))) sequence by 1;

after

where both operands of the condition do not Enter in a case . Just either one of them.

 Select  FIRST_NAME || '' || Where the user name is not (user name temp_amal where users select from ACCESS_DATE & gt accessed_by select USERNAME;): "P2610_RADIO: P2610_DATE_TO and col1 = (case = P2610_DATE_FROM and ACCESS_DATE" where users with "LAST_NAME" F 'then' F 'end))) sequence by 1;  

So, you want to make your question more dynamic. You have to do dynamic SQL query generation.


No comments:

Post a Comment