Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
insert into my_employee values (&empid, '&last', '&first', concat(lower(substring('first', 1, 1)), lower(substring('last', 1, 7))), &sal);
The error I'm getting is "Substring": invalid identifier. A little help please? Thanks!
It is "substr" not "substring"
I used to do this mistake often because "substring" is used in java and .net.