Find doctors in another specialty or condition.

A  |   B  |   C  |   D  |   E  |   F  |   G  |   H  |   I  |   J  |   K  |   L  |   M  |   N  |   O  |   P  |   Q  |   R  |   S  |   T  |   U  |   V  |   W  |   X  |   Y  |   Z  |  

 
select distinct dr, sysdate, lname, fname from vw_available_docs where upper(lname) like upper(:nameSearch) order by lname, fname
Results error: ORA-01722: invalid number