SQL ORACLE SELECT SORGULARI
select last_name as soyisim,
salary as Maaş,
salary * 12 “Yıllık Maaş”,
commission_pct as Komisyon_Oranı from hr.employees;
select last_name || ‘ ‘ || jop_id as Çalışanlar from hr.employees;
select last_name || ‘in bir aylık maaşı=’|| salary as yıllık_Maaş from hr.employees;
select distinct job_id from hr.employees;
describe hr.employess;
select * from hr.employees WHERE department_ıd=90;
select employee_ıd, last_name FROM hr.employees WHERE last_name=’Whalen’;
select * from hr.employees WHERE salary between 3100 and 3200;
select *from hr.employees WHERE last_name between ‘King’ and ‘Swith’
select last_name, salary, manager_id from hr.employees where manager_ıd in (100,101,102);
select *from hr.employees WHERE last_name in (‘Hartstein’,’King’,’Weiss’);
select *from hr.employees WHERE last_name LIKE ‘%il%’;
select *from hr.employees WHERE manager_ıd is null
select *from hr.employees WHERE manager_ıd is not null
select *from hr.employees WHERE salary >10000 and job_ıd LIKE ‘%MAN%’
select *from hr.employees WHERE job_ıd not in (‘IT_PROG’,’SA_REP’,’ST_CLERK’);
select *from hr.employees WHERE job_id=(‘SA_REP’) or job_id=(‘AD_PRES’) AND salary>15000;
select last_name,job_id,hire_date from hr.employees order by hire_date;
SELECT first_name,last_name,job_id,commission_pct from hr.employees order by commıssıon_pct DESC nulls last;
select * FROM hr.employees order by department_ıd desc nulls last, salary asc;
select * from hr.employees WHERE employee_ıd=100;
select *from hr.employees WHERE employee_ıd=&Çalışan_No;
select * from hr.employees WHERE job_id=&Meslek_Adı;
select * from hr.employees WHERE &Koşul; /* kendimiz koşul belirterek olurturduk.*/
select upper(first_name) from hr.employees; /* first_name tablosundaki verileri büyük harfe çevirme*/
select upper (‘merhaba’) from dual;
select lower (first_name) from hr.employees;/* first_name tablosundaki verileri küçük harfe çevirme*/
SELECT initcap(‘merhaba’) from dual;
select concat(first_name,last_name) from hr.employees;
select concat(concat(first_name, ‘ ‘),last_name) from hr.employees;
select substr (first_name,2,3) from hr.employees;
select first_name as isim, length (first_name) as İsmin_Uzunluğu from hr.employees;
select first_name as İsim, instr(firs_name,’a’)as Kaç_Kar from hr.employees;
select first_name as isim , replace(first_name,’a’,’*’) as Yer_Değ_Hali from hr.employees;
select * from hr.employees WHERE upper(last_name)=’HIGGINS’;
SELECT * from hr.employees WHERE lower(last_name)=’higgins’;
Yorum gönder