---

ALTER SESSION SET NLS_DATE_FORMAT=YYYY/MM/DD':
rem select * from hr.jobs;
rem select job title, min_ salary, max salary from hr.jobs;
rem
rem
select
last namell Ufrst name "Nazwisko i imie" from hr.employees:
rem select last name upper(last name) trom hr employees;
select last_name, salary wynagrodzenie, nvi(commission_pct,0) "Procent premia", salary* nvi(commission_ pct,0) "Kwota premii", salarytsalary*nvl(commission pct,0)
"Wynagrodzenie z premia" from hr. employees;