在Oracle中,有一個(gè)教師表teacher的結(jié)構(gòu)如下:
IDNUMBER(5),NAMEVARCHAR2(25),EMAILVARCHAR2(50)
下面哪個(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;
A.Top
B.First
C.Limit
D.rownum