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
The Square The idea of a paperless monetary system takes a big leap forward thanks to the Square credit card reader. No longer is there a need for an expensive credit card machine that is fixed to a land line. Owners of an iPhone‚ iPad‚ or an Android device are now able to swipe credit card payments anywhere at anytime and have it deposited directly into their bank account. The Square is a 1 3/4” x 9/10” x 1/2” cubed shaped plastic piece of hardware that plugs directly into the 3.5mm audio jack
Premium Credit card Smart card
DeFehr began creating household furniture from his woodworking shop in the basement of his home. This solo operation soon turned into a booming business with expansion opportunities‚ but also encountered challenges along the way. In 1964‚ this one man business‚ turned into DeFehr Manufacturing Ltd (DML)‚ consisting of 50 employees working out of a 45‚000 square foot building. The firm’s sales and annual revenue continued to grow between the 1960’s – 1970’s‚ with 20% of the sales coming from exports
Premium International trade Mexico North American Free Trade Agreement
kick off their shoes. And even the sweetest smelling person can do a decent job stinking up a pair of shoes by running a few miles in them. So what’s going on here? Why do your feet have a stronger odor than the rest of you does? The main thing that feeds foot smell is sweat. With more than 250‚000 sweat glands each‚ your feet are among the most perspiring parts of the body. In one day‚ each foot can produce more than a pint of sweat! Sweat is basically just salt and water‚ though‚ so it doesn’t have
Free Olfaction Odor Smell
Flooring Living Room I chose the Bamboo flooring foe the living room area because it is a truly sustainable harvested grass that regenerates at a speed faster than hardwood. Bamboo mature rapidly but harvesting does not kill the plant. Duro-design uses only fully mature Moso bamboo which is selected for superior strength and maximum hardness. I think it fits in to my overall concept because I believe wood flooring is traditional. Duro Design Ash Brown bamboo flooring Flooring Bedroom I chose
Premium Textile Carpet Green
a condom? A. too expensive B. they are sold too far away C. embarrassed D. it is hard to find a good brand 3. In order to know the reason why there are 30% buyers still have some reservations about buying condoms‚ first of all‚ we have to use the survey methods of primary research. Secondly‚ the motivation research can be used‚ which consists of projective technique and focus group discussion. We can give some incomplete sentences and ask the research respondent to complete them. Therefore
Premium Condom Marketing Causality
Gina Rose Lee Lonero Jaclyn Kundys English 021 20 March 2014 Bound Lotus Feet We are all entitled to have our own secrets but‚ we are bound by the secrets we share. So I ask‚ what would you do if you discovered a secret that could
Premium Chinese culture China Culture
Analysis on Feet Feet is a prose talking about a little child looking at his sister’s death. The story is set in a post war period‚ when poverty and diseases are everywhere. We can know this by looking at the date written under the title‚ “September 1948”. The story happened in a working class family in Ireland. We can know that it is set in Ireland from the little sister’s name. From the sentence in line 7‚ “ Una. My younger sister‚ Una.” We know that her name is Una‚ which is an Irish name‚
Premium Question Sentence Family
SAGA FURNITURE TRADING BUSINESS IMPROVEMENT PROPOSAL AHMAD AFFANDI BIN NIK JAAFAR (P12D238F) MOHAMAD NORAZAM BIN ABDULLAH (P12D126F) MUHAMMAD ZULFARIS BIN MOHD SALLEH (P12D250F) INTRODUCTION TO SAGA FURNITURE TRADING Saga Furniture Trading was established in 2007 but initially registered as Tenaga Tulen Sdn Bhd in 1985. It is a family business. Saga Furniture Trading located at Lot
Premium Laborer
1. Discuss three management events that occurred that should have been a “red flag” to the auditing firm. The auditing firm has been in engagement with the company throughout the period when the fraud was being committed. One of the common and clear indicators of possible fraud was the company’s cash flow statement. The company experienced positive growth in its profits from the year 1996 through to the year 1998. However‚ a close analysis of the cash flow statement shows that the company had experienced
Premium Balance sheet Generally Accepted Accounting Principles Financial statements