LEFT function didn't work

[lionelcanon]

Hello,
why left function sql doesn't work in DBeaver ?

SELECT LEFT('abcdefghij',1) FROM dual;

Thanks a lot :)

[LonwoLonwo]

Hello.
What database do you use?
What error do you have, or how exactly it doesn't work?

[lionelcanon]

hello,
Im use an oracle database.

Error its : SQL Error [904] [42000]: ORA-00904: "LEFT" : identificateur non valide

[LonwoLonwo]

The Oracle database does not support the LEFT function.
You can take a look at this answer:
https://stackoverflow.com/a/45495735

[lionelcanon]

thanks a lot, it's ok with substr