Urgent Bhayyas Please Help Me Please

[krishnareddy218]

nenu india lo job kosam chala rojula nunchi try chestunna.naaku oka valla nunchi call vaachindhi memu oka task istham.if u do it then u will be called for the interview ani.vallu naaku plsql meeda task iccharu.just only 5 questions.can anyone help me plz plz thanks.

[hotmaddy]

Help...

[JAPAN]

ltt

[ManOnFire]

plsql a?? kaasepu aagithey

[JAPAN]

aaa 5 questions kooda ikkada veey............emanna telisthe evaraina answer istharu

[Idly Vishwanatham]

PM chey evaru aina help chesthanu ante, malli risk emo.. Leda ikkada veyyi, neeku answers vachaka thread delete chepinchu.. Also paina company peru raasav anukunta kada, edit chesi Adi delete chey

[krishnareddy218]

k

[krishnareddy218]

no actually dantlo oka diagram undhi so,adhi ikkada paste kavatledhu.help chese vallu dayachesi mee mail id iccharu antey nenu meelu post chestha.avi 5 programs.so atleast oka 3 aina pampinchali nenu vallaki.thanks

[JAPAN]

neeku entha tyme vundhi

[missionxp]

mari anni sarlu pls anaku va .. maree touch chesthunnav.. hope someone will help..

mee frnds evarinaina adugu ba.. ikkada andharu db la browsing tho busy ga untar...

[cherlapalli_jailer]

what r those 5 Q? boss...let me know

[krishnareddy218]

actually night varaki vallaki pampinchalanta.kani dantlo oka diagram.i dont know why adhi ikkada post kavatledhu


1. Create tables for below components based on the screenshot given below.

1. EMPLOYEES
2. DEPARTMENTS
3. LOCATIONS
4. JOBS
5. COUNTRIES
6. JOB_HISTORY
7. JOBS

[img]file:///C:/Users/homr/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg[/img]

2. Create a Package with specific inset procedure for each table to insert records into above tables. Use sequences for primary key columns for each table while inserting the records into the tables.
3. Understand the table relationships shown in above screen and use the insert procedures to insert the records into each table. Additionally insert the records in each table in a logical order to ensure that any foreign key values that are to be populated should be exist in their respective table. For ex. If the record is being inserted into EMPLOYEE table, values for manger_id, department_id,job_id should be already exists in EMPLOYEES,DEPARTMENTS,JOBS tables respectively.

[right]Contd..2[/right]
[center]:2:[/center]


4. Create a stored function called GET_JOB_COUNT to retrieve the total number of different jobs on which an employee worked.
[indent=1]a. The function should accept one parameter to hold the employee ID. The function will return the number of different jobs that employee worked until now.[/indent]
[indent=1]b. Also Add exception handling to for invalid employee ID.[/indent]
5. Create a stored function called GET_SERVICE_YRS to retrieve the total number of years of a service for a specific employee.
[indent=1]a. The Function should accept employee ID as a parameter and return the number of years of a service.[/indent]
6. Create a stored procedure called UPD_SAL to update the minimum and maximum salaries for a specific job ID in the JOBS table.
[indent=1]a. Pass three parameters to the procedure, Job ID, Minimum salary and Maximum salary[/indent]
7. Create a PL/SQL stored procedure with a cursor to select employee name, salary, hire date from EMPLOYEE table. Read each row from the cursor and if the salary is between 1000 to 5000 then give an increment of 10% and if the salary is between 5000 to 10000 and if he was hired after the 31-DEC-2012 and give an increment of 5 %. Additionally update EMPLOYEE table back with new salary.

[JAPAN]

vuriki poyanu annav.......interview call vachinda............naku mail chey mail id pm chesa chudu........kaani entha time vundhi adhi cheppu mundu

[krishnareddy218]

meeru aa link click cheste aa diagram vasthundhi.chundandi friends naaku dantlo 4,5,6 questions mathram programs kavali.migatha 4 questions i know them .thanks

[krishnareddy218]

bhayya nenu urloney unnanu