Select ename,lower(sub str(ename,1,rou nd(length(ename )/2)))||upper(sub str(ename,round (length(ename)/2)+1,length(ena me))) a from emp ;
executed....... ..............
KARTHIK1244
Last Activity: Jan 10 '12, 08:43 AM
Joined: Jan 10 '12
Location:
-
KARTHIK1244 replied to sql query to display half employee name in upper case & other half in lower casein Oracleanswer
Select ename,lower(sub str(ename,1,rou nd(length(ename )/2)))||upper(sub str(ename,round (length(ename)/2)+1,length(ena me))) a from emp ;Leave a comment:
No activity results to display
Leave a comment: