Sunbelt Computer Software

PL/B Language Development and Support

Home
About
Blog
Products
Forum
Support
Contact

GitHub - srikanthpragada/plsql: PL/SQL Examples · GitHub

Branches Tags

Name	Name	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