Repository navigation

plsql

Public

About

PL/SQL Examples

97 stars

6 watching

Report repository

Name		Name	Last commit message	Last commit date
BONUS_CALCULATION.SQL		BONUS_CALCULATION.SQL
Calculate Salary		Calculate Salary
Details of Departments		Details of Departments
Display Department Details		Display Department Details
Display Department name and HOD		Display Department name and HOD
Display Details of Employee		Display Details of Employee
Display Employees By Dept		Display Employees By Dept
Display Employees and History Count By Job		Display Employees and History Count By Job
Display department name and HOD using cursor		Display department name and HOD using cursor
Display employees by department		Display employees by department
Employee Information		Employee Information
Employees Count By Salary Range		Employees Count By Salary Range
Explicit cursor example		Explicit cursor example
Find out salary hike		Find out salary hike
Monthly emp count for year with max employees		Monthly emp count for year with max employees
Populate DEPT_EMP table		Populate DEPT_EMP table
Procedure Change_Manager		Procedure Change_Manager
README.md		README.md
Salary History Trigger		Salary History Trigger
Update salary based on conditions		Update salary based on conditions
Update_Salary Procedure		Update_Salary Procedure
VARRAY Demo		VARRAY Demo
change_department_manager.sql		change_department_manager.sql
change_salary procedure		change_salary procedure
count_employees_by_month.sql		count_employees_by_month.sql
current_job_start_date.sql		current_job_start_date.sql
current_job_start_date_for_all_employees.sql		current_job_start_date_for_all_employees.sql
delete_job procedure		delete_job procedure
delete_rows		delete_rows
dept_details_lessthan_5_emp.sql		dept_details_lessthan_5_emp.sql
dept_highest_salaried_emp.sql		dept_highest_salaried_emp.sql
dept_highest_salaried_emp3.sql		dept_highest_salaried_emp3.sql
dept_highest_salaried_emp_2.sql		dept_highest_salaried_emp_2.sql
dept_hod_city_noemployees.sql		dept_hod_city_noemployees.sql
deptname_highest_exp_employee.sql		deptname_highest_exp_employee.sql
display details of highest paid employees in dept		display details of highest paid employees in dept
display_dept_costly_experienced_emp.sql		display_dept_costly_experienced_emp.sql
display_dept_details2		display_dept_details2
displays_dept_details.sql		displays_dept_details.sql
employee_info.sql		employee_info.sql
employees_by_year.sql		employees_by_year.sql
employees_old_new_salaries.sql		employees_old_new_salaries.sql
employees_percentage_by_month		employees_percentage_by_month
employees_salary_gap		employees_salary_gap
employees_salary_log		employees_salary_log
ex_handling_demo1.sql		ex_handling_demo1.sql
get_employees_by_dept.sql		get_employees_by_dept.sql
get_employees_by_job function		get_employees_by_job function
get_highest_paid_employees.sql		get_highest_paid_employees.sql
get_job_history function		get_job_history function
hike_salary_by_dept		hike_salary_by_dept
hike_salary_for_150.sql		hike_salary_for_150.sql
insert_entertainment_dept.sql		insert_entertainment_dept.sql
interchange_salary.sql		interchange_salary.sql
job_summary_2.sql		job_summary_2.sql
jobs_summary.sql		jobs_summary.sql
manager_job_history function		manager_job_history function
missing_employee_ids_with_exceptions.sql		missing_employee_ids_with_exceptions.sql
missing_employeeids.sql		missing_employeeids.sql
month__employees__recent_year.sql		month__employees__recent_year.sql
salary_stats.sql		salary_stats.sql
show_employee_grade.sql		show_employee_grade.sql
trg_commission_check		trg_commission_check
trg_department_manager_check		trg_department_manager_check
trg_employees_log		trg_employees_log
trg_salary_change_log		trg_salary_change_log
trg_start_date_hire_date_check		trg_start_date_hire_date_check
using implicit cursor		using implicit cursor

Repository files navigation

plsql

PL/SQL Examples

About

PL/SQL Examples

97 stars

6 watching

Report repository

Releases

Packages

Contributors

Languages