bowshy

摘要： Statement 1: SELECT employee_id, last_name, job_id, manager_id FROM employees START WITH employee_id = 101 CONNECT BY PRIOR employee_id = manager_id AND manager_id != 108 ; Statement 2: SELECT em... 阅读全文

摘要： 测试表: create table products(prod_id number(10), prod_name varchar(20)); create index idx_products_1 on products(upper(prod_name)); SQL> select upper(prod_name) from products a ; Execution Plan... 阅读全文