3 Section-B(PL/SQL) 16. Write a Pl/Sql program to raise the employee salary by 30%‚ who have completed their 40 years of service. declare cursor c3 is select * from emp where extract(year from sysdate)-extract(year from hiredate)>40 for update; e emp%rowtype; begin open c3; loop fetch c3 into e; exit when c3%notfound; update emp set sal=e.sal+(30/100)*e.sal where current of c3; end loop; close c3; end; / 17. Write a Pl/Sql program to check the given number is Armstrong ‘or’ not. declare n number(3);
Premium SQL
Before participating in the Student Success alcohol program‚ I felt very alone‚ as I have never drunk alcohol. Most people assume every college student drinks‚ just as I did previously; the program has taught me valuable information that I wouldn’t have learned otherwise. I learned that I am not alone‚ that one in four college students have never consumed alcohol and in addition‚ only six percent of college students drink regularly. I come from a family of non-drinkers (they will have an occasional
Premium High school College Education
Human Services Program: Commonalities and Successes Shannon Williams BSHS/425 July 27‚ 2015 Gina Harper Human service organizations are unique organizations they are different than any other in the general business world. According to Lewis and Packard (2012)‚ human service organizations work together towards a common goal. Human service professionals work in different settings and in various ways to assist clients and improve their way of life. This shared vision brings other
Premium Federal government of the United States Childbirth Government
My goal for this year in the CBK program is to finish as many classes as possible and hopefully pass the program by the end of the school year. In order to achieve this goal I intend on going to school as often as I can. I also plan on taking as many classes as I can to gain the credits and knowledge I need to pass everything. I plan on putting in a lot of effort so I may continue to be in a straight path to better my future. The first strategy I am going to put in place is to go to school three
Premium High school Education College
major elements that makes crime prevention programs effective: 1. Continued commitment from those involved 2. Believing that it will work 3. The program needs to be designed with the purpose of reducing the opportunities for a crime to be committed 4. Learning what needs to be done to harden the target for the criminal Two crime prevention programs I was involved in were Neighborhood Watch and CPTED‚ which we used many times. The Neighborhood Watch program proved to be effective in a number of incidents
Free Crime Crime prevention
1. Indian companies‚ which used to focus mainly on sales training programs for their own sales force‚ are now extending these initiatives to their business partners. What are the major reasons behind the increasing prominence of such initiatives among Indian companies? Also throw light on the advantages and disadvantages of outsourcing the training activities to third parties. Ans: The reason for extending sales training program initiatives to business partners is due the fact that consumers perceive
Premium Sales Marketing Skill
on Designing a Training Program Course – Training and Development (EM-550) SUBMITTED TO Dr. Md. Ataur Rahman Professor Department of Management University of Dhaka‚ Bangladesh SUBMITTED BY Name ID Batch Md. Shamsul Arefin 3-10-18-057 18th University of Dhaka‚ Bangladesh Table of Contents Topic Page No. Designing a Training Program Definition of Training Design 1 Importance of Designing a Training Program 1 Objectives of Designing a Training Program 2 Guidelines of Designing
Premium Communication design ADDIE Model Design
post-secondary education‚ I would like to study in the Health Sciences Program at McMaster university for four years to receive my bachelor degree‚ and then to follow this‚ apply to medical school. The reason for why I want to go specifically into the Health Sciences Program at McMaster university is because of its very unique approach to teaching their students the studies of health‚ wellness‚ and illness. The program is the only program in Ontario that has a full range of departments within health sciences
Premium Medicine Medical school Physician
Mandatory Service Program There are many debates concerning advantages and disadvantages of mandating community service‚ however‚ the practice of compelling adolescents to take part in community service is increasingly common. People seek to understand the relationships between mandatory community service and volunteering. A key distinction between mandated community service and volunteering is the freely-chosen nature of the latter activity compared to the compulsory nature of the former
Premium Youth Civic engagement Community service
July 6‚ 2013 Bridge Writing Dr. PHP Journal #3 The Positive Impacts from the Summer Bridge Program The Summer Bridge Program is designed to help students transition from high school to college. It provides learning opportunities in order for the new graduates to acquire the knowledge and skills needed for college success. This program has made three positive impacts on me thus far. The program focuses on my development academically‚ and socially. The first impact is in my math. I am not
Free High school University Critical thinking