dataset not returning doing select oracle sql

Question

I have a data in oracle db DJSHJSJD-DJDJJJDK-D'FJDJSS when i tried to do a filter it is throwing error

select * from test
where dummy='DJSHJSJD-DJDJJJDK-D'FJDJSS' ;

ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:

score 0 · Answer 1 · answered May 04 '20 at 14:45

0

where dummy='DJSHJSJD-DJDJJJDK-D''FJDJSS' ;

I.e. double the quote character inside the string literal.

answered May 04 '20 at 14:45

jarlh

42,561
8
45
63

excellent for the quick response - short explanation ? – Data2explore May 04 '20 at 14:48
The SQL scanner otherwise thinks the string is `'DJSHJSJD-DJDJJJDK-D'` only, followed by `FJDJSS' ;`, where FJDJSS makes no sense. – jarlh May 04 '20 at 14:52

dataset not returning doing select oracle sql

1 Answers1