Hi guys, I have four tables those are emp,dept,eliminate and uneliminate. i wrote small cursor..when i run, it display one error (ORA-01403 nodata found)... The query is: Declare cursor c1 is select e.ename emp_name from emp e,dept d where e.deptno=d.deptno group by deptno; r1 c1%rowtype; test_emp varchar2(200); begin for r1 in c1 loop begin select eliminate_emp into test_emp from eliminate t,uneliminate ut where t.number=ut.number and t.deptno=e.deptno and rownum<1; end; dbms_output.put_line(r1.emp_name); end loop; end; Thanks...

2599

i want a list of top 10 nationalized banks in inda....can some expects help me???

2294

how do i copy first 10 records from one sequntial file to another sequential file by using JCL program?

2739

Dear HCM Gurus: I am facing a problem in PCR as per decisive about deduction wage type restricted as per Government rules that if an employee payment period is < then 15 days then deduction are not required to made from employee, Nomenclature of PCR is: RTE=TKDIVI RTE/2 RTE?TKSOLL < PPPAR U Unpaid absences duing Payroll Period *ADDWT U THEN RTE=TASOLL RTE-GAAU04 RTE*2 RTE?TKDIVI < ADDWT& Variable Table = ADDWT* OT TABLE > ADDWT* OT TABLE SO aforesaid mentioned PCR is applied so when employee Leaving action has been performed on 01.10.2010 and rentry into company is performed on dated 11.10.2010 So sytem is not displaying deduction wage type in LPC but if we perform leaving action on 16.10.2010 then all deduction displayed proportionately because from 01.10.2010 to 16th payment days fullfills but client is insisted that employee leaved company on 01.10.2010 and rejoin company on 11.10.2010 and by this way he worked 21 days in this month thus payment period is not less rather more than 15 days and system should have made deductions. Kindly guide me that how included PCR with Rejoining into comapny so pleases explain nomencalture of PCR if an employee rejoin the company and his payment period fullfill requirement. Kindly help Regards Barket Ali Zafar SAP HR Consultant Siemens Engineering Co Ltd PIFRA Project ,Islamabad +92-300-5521524

3152

ORA-26027: unique index string.string partition string initially in unusable state

6746

ORA-26079: file "string" is not part of table string.string

1958

write the value of x and y after execution of the statements: int x=19,y; y=x++ + ++x; x++; y++;

1935

hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

2539

Program ended with error or warning, return code: 4

14344

Jetking is C C

2659

Answers for Complete This Song B_C_A_A _IL K_A KA_E, S__AN J__E B__D_ J__E

3223

ORA-26094: stream format error: input column overflow

2808

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2731

dear sir I want singal maintainer(iii& ii) solved question paper in every year in every board in rrb. If you collect these and sent these my mail-id i shall very grateful to you. thanking you your's faithfully soma saha

2410

write a database figure to implement the master detained relationship.

2936