Skip to content
Navigation Menu
Sign in
Appearance settings
Platform
AI CODE CREATION
GitHub Copilot
Write better code with AI
GitHub Copilot app
Direct agents from issue to merge
MCP Registry
Integrate external tools
DEVELOPER WORKFLOWS
Actions
Automate any workflow
Codespaces
Instant dev environments
Issues
Plan and track work
Code Review
Manage code changes
Code Quality
Enforce quality at merge
APPLICATION SECURITY
GitHub Advanced Security
Find and fix vulnerabilities
Code security
Secure your code as you build
Secret protection
Stop leaks before they start
EXPLORE
Why GitHub
Documentation
Blog
Changelog
Marketplace
View all features
Solutions
BY COMPANY SIZE
Enterprises
Small and medium teams
Startups
Nonprofits
BY USE CASE
App Modernization
DevSecOps
DevOps
CI/CD
View all use cases
BY INDUSTRY
Healthcare
Financial services
Manufacturing
Government
View all industries
View all solutions
Resources
EXPLORE BY TOPIC
AI
Software Development
DevOps
Security
View all topics
EXPLORE BY TYPE
Customer stories
Events & webinars
Ebooks & reports
Business insights
GitHub Skills
SUPPORT & SERVICES
Documentation
Customer support
Community forum
Trust center
Partners
View all resources
Open Source
COMMUNITY
GitHub Sponsors
Fund open source developers
PROGRAMS
Security Lab
Maintainer Community
Accelerator
GitHub Stars
Archive Program
REPOSITORIES
Topics
Trending
Collections
Enterprise
ENTERPRISE SOLUTIONS
Enterprise platform
AI-powered developer platform
AVAILABLE ADD-ONS
GitHub Advanced Security
Enterprise-grade security features
Copilot for Business
Enterprise-grade AI features
Premium Support
Enterprise-grade 24/7 support
Pricing
Type
/
to search
Sign in
Sign up
Appearance settings
You signed in with another tab or window.
Reload
to refresh your session.
You signed out in another tab or window.
Reload
to refresh your session.
You switched accounts on another tab or window.
Reload
to refresh your session.
Dismiss alert
{{ message }}
srikanthpragada
/
plsql
Public
Notifications
You must be signed in to change notification settings
Fork
63
Star
97
Code
Issues
2
Pull requests
1
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Projects
Security and quality
Insights
master
Branches
Tags
Go to file
Code
Open more actions menu
Folders and files
Name
Name
Last commit message
Last commit date
Latest commit
History
70 Commits
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
View all files
Repository files navigation
README
More
items
plsql
PL/SQL Examples
About
PL/SQL Examples
Resources
Readme
Activity
Stars
97
stars
Watchers
6
watching
Forks
63
forks
Report repository
Releases
Packages
Contributors
Languages
You can’t perform that action at this time.