Vlakarmis wrote:"Doesn't work" is not an actionable error message.
I type the following query based on what I am learning in terms of Single-row Functions and it seems to work in SQL developer but for some reason not in SQL Plus ? Can anyone tell me where i am going wrong?
SUBSTR(Job_title, 1, 10)
This is just to test the function's abilities and to see what it does but I was wondering as to why it doesn't work on the SQL plus prompt. Any help would be greatly appreciated.
Select Job_title, SUBSTR(Job_title, 1, 10), -- <--- added the missing comma SUBSTR(Job_Title, 11) from jobs;