1,用逻辑运算符AND和 OR来联结多个查询条件
eg:
SQL> select * from customers where dob > to_date(‘1970-01-01’, ‘yyyy-mm-dd’) and first_name like ‘D_’;SQL> select * from cust
1,用逻辑运算符AND和 OR来联结多个查询条件
eg:
SQL> select * from customers where dob > to_date(‘1970-01-01’, ‘yyyy-mm-dd’) and first_name like ‘D_’;SQL> select * from cust