07_24 오라클...

select * from temp;
delete from temp where name ='이지수';

 

어디갔니 ㅜㅜ

 

 

select * FROM employees;

select first_name||last_name as full_name from employees;

select first_name||last_name as full_name,salary,department_id from employees where department_id<30 and salary<10000;

select first_name||last_name as full_name from employees where department_id = 30 and salary<=10000 and hire_date<'06/01/01';

select * from employees where (department_id=30 and salary <=10000 ) or ( department_id=60 and salary>=5000);

select * from employees where (employee_id>=110 and employee_id<=120) and (salary>=5000 and salary<=10000);

select * from employees where not (employee_id>=110 and employee_id<=120);

select * from employees where department_id in(30,60,90);

select * from employees where not department_id in(30,60,90);

select first_name||last_name as full_name , phone_number from employees where phone_number like '590%';