-
stored proc help
I would like to create a package that contains to PL/SQL blocks:
department
dept_id location
1 London
2 New York
3 Singapore
4 Tokyo
employee
emp_id dept_id salary tier_id
1 2 20000 4
2 4 200000 1
3 3 25000 4
4 1 60000 2
5 1 30000 3
tier
tier_id tier_name
1 Director
2 Manager
3 Analyst
4 Intern
The first procedure will take in an department ID and will return both the current timestamp and a list of the different distinct tiers belonging to that department ID. These will be returned as two separate parameters.
The second stored procedure will take in a tier ID and provide back the second highest salary for that tier.
Any help would be appreciated
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|