oaklanders
Technical User
- Dec 9, 2007
- 38
In my Oracle 9i I tried this and it gave me back an error saying fullname is invalid.
This works:
Please advise how I can get it working the first attempt working?
Code:
select firstname || ' ' || secondname as fullname where fullname like '%Jo%'
This works:
Code:
select firstname || ' ' || secondname where firstname || ' ' || secondname like '%Jo%'
Please advise how I can get it working the first attempt working?