在Oracle中,有一個(gè)教師表teacher的結(jié)構(gòu)如下:
下面哪個(gè)語(yǔ)句顯示沒(méi)有Email地址的教師的姓名()。
A.select name from teacher where email=null
B.select name from teacher where email<>null
C.select name from teacher where email is null
D.select name from teacher where email is not null