3.如果表中提到的角色是'MANAGER'或'Manager'怎么辦？您不能撰寫三個不同的查詢來獲得結果。使用指定檢查角色管理器的所有可能值的選項是什么？
--selecting employee who is not a manager
create table employee(
employee_id number(10) NOT NULL,
employee_name varchar2(50),
employee_sal number(10),
employee_role varchar2(50),
employee_age number(10),
CONSTRAINT employee_pk PRIMARY KEY(employee_id)
);
insert into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(12,'ravi',5676,'dse',23);
insert into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(13,'sai',85676,'tester',21);
insert into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(15,'chandu',4676,'developer',28);
insert into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(16,'raju',7676,'tech lead',22);
insert into employee(employee_id, employee_name, employee_sal, employee_role, employee_age)values(17,'teja',9676,'manager',29);
select * from employee
where employee_role !='manager';
uj5u.com熱心網友回復：
快速而骯臟的方法是與轉換為大寫或小寫的列進行比較：
SELECT * FROM employee WHERE UPPER(employee_role) != 'MANAGER';
根據您的語言和用途，更正確的方法是將 COLLATE 運算子添加到搜索中。有關 COLLATE 運算子的更多詳細資訊，您可以從這篇文章開始：https : //blogs.oracle.com/sql/post/how-to-do-case-insensitive-and-accent-insensitive-search-in-oracle -資料庫
uj5u.com熱心網友回復：
從 12.2 開始：
select * from employee
where employee_role collate binary_ci != 'Manager';
binary_ai 另外是重音不敏感的。
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/393568.html
下一篇：長時間在程序與查詢塊中運行