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’;

adalramazan

Yorum Yap