● 비교 연산자 ( = , != , ^= , <> , > , < , >= , <= , is null , is not null ) > ORACLE

• 목록

● 연산자 : = , != , ^= , <> , > , < , >= , <= , is null , is not null

01. select * from notice;

02. select * from notice where writer = '1111';

03. select * from notice where writer != '1111';

04. select * from notice where writer ^= '1111';

05. select * from notice where writer <> '1111';

06. select * from notice where hit > 99; 

06. select * from notice where signdate is null; 

07. select * from notice where signdate is not null;