1. Write a trigger, when add employee information or update the salary, if the salary is less than the minimum wage, minimum wage, if salary is greater than the maximum salary, wages biggest

2. Write a stored procedure, realize the member's name, department, position, salary information paging query,

3. Write a trigger, when to add records to the JOB table, do not specify a JOB_ID, trigger with sequence to add value,

4. As the job table, cancel job_name unique constraints, add the same data with the existing four records, there are eight records, two repeat

5. On the basis of on the topic, writing a block of code or a stored procedure, delete duplicate records in the job table, leaving only make every job a, (to keep has cited job_id)
How to write these problems?

CodePudding user response:

http://www.rleelr.com/index.php/2019/11/10/oracle-%e8%a7%a6%e5%8f%91%e5%99%a8%e5%ae%9e%e7%8e%b0%e8%87%aa%e5%a2%9e%e5%8a%a0/