How to make a query not referring to the table

Asked Nov 03 '22 at 08:14

Active Nov 03 '22 at 08:14

Viewed 23 times

I need to calculate amount of spaces in string by this query

SELECT LEN(RTRIM(LTRIM('Im i student of the Academy')))-LEN(REPLACE('Im i student of the Academy',' ',''))  as Spacecount

But i get "ORA-00923: FROM keyword not found where expected" Probably this question seems stupid but i really dont know how to deal with it

asked Nov 03 '22 at 08:14

Максим

Try to add "from dual" at the end – Jonas Metzler Nov 03 '22 at 08:16
Somewhat simpler code than yours: `select regexp_count('Im i student of the Academy', ' ') result from dual;` – Littlefoot Nov 03 '22 at 08:56

0 Answers0