Skip to content

amygbAI/plsql

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

70 Commits
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

Resources

Readme
Activity

Stars

0 stars

Watchers

0 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

No packages published

Languages

  • PLSQL 66.5%
  • TSQL 28.6%
  • SQLPL 4.9%