Oracle_exercise_.docVIP

day01 1.环境变量错误或是没有这个数据库 2. select last_name 2 from s_emp 3* where last_name like __a% LAST_NAME -------------------- Chang Ngao 3.SQL select first_name 2 from s_emp 3 where first_name like %a% and first_name like %e%; FIRST_NAME -------------------- Carmen Roberta Elena Alexander Bela 4.1 select first_name,salary,commission_pct 2 from s_emp 3 where commission_pct is not null 4* order by salary,commission_pct SQL / FIRST_NAME SALARY COMMISSION_PCT -------------------- ---------- -------------- Colin 1400 10 An