Urgent Bhayyas Please Help Me Please

[krishnareddy218]

naaku indhakey vaalu call chesi task pamparu

[missionxp]

[quote name='JAPAN' timestamp='1369134252' post='1303778753']
vuriki poyanu annav.......interview call vachinda............naku mail chey mail id pm chesa chudu........kaani entha time vundhi adhi cheppu mundu
[/quote]
u r great ba baga help chesthav andahriki

[factorial]

arey question ikkade paste chesaventi. Niku task ichinodu google search cheste direct ide link vastadi. Nuvu same answer submit cheste dorikipothav.

[missionxp]

[quote name='factorial' timestamp='1369134537' post='1303778765']
arey question ikkade paste chesaventi. Niku task ichinodu google search cheste direct ide link vastadi. Nuvu same answer submit cheste dorikipothav.
[/quote]

generic questions ba ilantivi chala untai..... chala refine chesi google serach kottina search lo 1st page lo kanapadavu anukunta..
nenu chusa nuvvu chepina tharuvahta .. raavatledhu

[cherlapalli_jailer]

@NOJOB

Aa diagram lo table fileds etc vundi vuntayi

so you create the tables and list the details of the tables instead of sending the diagram..

create table syntax simple

B4 that first create seqence of all PK(s)

what tool u r using to do this task?

[cherlapalli_jailer]

once table creation over then u can finish the rest of the tasks like function and other procedure..not at all difficult

[krishnareddy218]

sql*plus,naaku andulo 4,,5,6 questions ki answers ravtledhu.naaku functions lo knowledge ledhu.so,akkada problem avtundhi

[JAPAN]

pampinchina friend ki wait chey.............how much time u have....................

[cherlapalli_jailer]

[quote name='NOJOB' timestamp='1369134906' post='1303778785']
sql*plus,naaku andulo 4,,5,6 questions ki answers ravtledhu.naaku functions lo knowledge ledhu.so,akkada problem avtundhi
[/quote]
tbl strucuture and nuvvu raasindi ikka veyyi

fixing cheyyavachu

[JAPAN]

[quote name='missionxp' timestamp='1369134419' post='1303778761']
u r great ba baga help chesthav andahriki
[/quote]

ento baa nuvvu mareenu........aa program seperate ga pettukundam le..............

[cherlapalli_jailer]

for Quest 4

i will write the SQL which very simple
you can pull from history table

SYNtax PL CHECK FOR ERRORS AS I DON'T HAVE ANY sql EDITOR TO CHECK I DID NTO CHECk






CREATE PROCEDURE GETJOBCOUNT
int EMP_Id
BEGIN


cursor c1 is
select count(*) job_cnt
from hisotry
where name = employee_id group by job_id;

BEGIN

total_cnt := 0;

FOR employee_rec in c1
LOOP
total_cnt := total_val + employee_rec.job_cnt
END LOOP;


if total_cnt = 0
GOTO: EXCEPTION

RETURN total_val;

EXZCEPTION
DBMS.outpt("EMP ID PROVIDED IS WRONG ")
END


END

[cherlapalli_jailer]

for 5

CREATE FUNCTION get_service_yrs
emp_id IN int
RETURN int
AS
BEGIN
cursor gs is

select MONTHS_BETWEEN(sysdate,hire_Date) months from employees where employee_id - EMP_ID


return (gs.months)/12
END
;

[cherlapalli_jailer]

CREATE PROCEDURE UPD_SAL
job_id int,
Min_sal float,
MAX_SAL float
as
BEGIN
update JOBS set min_salary= min_sal , max_salary=MAX_SAL where job_id = job_id ;
END
;

[cherlapalli_jailer]

for Quest 4

i will write the SQL which very simple
you can pull from history table

SYNtax PL CHECK FOR ERRORS AS I DON'T HAVE ANY sql EDITOR TO CHECK I DID NTO CHECk




type error it seems for Q4 i already gave above

[crazyhorse]

jailer mayya.......