Oracle under Common Query UPDATE command (ID number to judge men and women, update the statement Multi-table query)

1.update data

UPDATESET= (selectfromwhere t.xh=  b.vlbi_ XH)wherelike'14%';

2. Judging men and women according to their ID numbers

 Decode (mod (To_number (substr (  ID number  ', 17, 1) ", Span style= "color: #800000; Font-weight:bold; " >2), 0, 2 "" 1 ") 
 A. Intercept the second-to-last digit of the ID first 
 B. is divisible by 2 
 C. If the remainder is 0, Then 2-female 
 D. If the remainder is not 0, then 1-male 
            

Select decode (mod (To_number (substr (' ID number ')12 0 ' 2 ' ' 1 ' )  from dual

Oracle under Common Query UPDATE command (ID number to judge men and women, update the statement Multi-table query)