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...

2601

hi, i am trying to do modular test tree in winrunner but i am getting error like "Error in the Expression list",can you please tell e what kind of error is this? thanks.

2354

How to create a program that lists the capital country when told what the original country is? (Terribly sorry, I'm a novice programmer and would appreciate any help ;). Cheers, Alexxis

1137

How can be avoid the Error while being Human we do mistakes???

2594

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.

2428

2. A student studying Information Technology at Polytechnic of Namibia is examined by coursework and written examination. Both components of assessment carry a maximum of 50 marks. The following rules are used by examiners in order to pass or fail students. a. A student must score a total of 40% or more in order to pass (total = coursework marks + examination marks) b. A total mark of 39% is moderated to 40% c. Each component must be passed with a minimum mark of 20/50. If a student scores a total of 40% or more but does not achieve the minimum mark in either component he/she is given a technical fail of 39% (this mark is not moderated to 40%) d. Grades are awarded on marks that fall into the following categories. Mark 100-70 69-60 59-50 49-40 39-0 Grade A B C D E Write a program to input the marks for both components (coursework marks out of 50 and examination marks out of 50), out put the final mark and grade after any moderation. [30]

2881

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

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

1958

I'm having trouble with coming up with the correct code. Thank You!! The assignment was to write a program using string functions that accepts a price of an item and displays its coded value. The base of the keys: X C O M P U T E R S 0 1 2 3 4 5 6 7 8 9 Sample I/O Dialogue: Enter Price: 489.50 Coded Value: PRS.UX

2164

The employee runs big client-server applications and must quickly transfer large files. The company wants the best cost/benefit on this connection. What would be the most practical solution?

2795

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1620

when will we use lsmw , bdc and bapi? which will be easy to use and which is used for which type of data

2517

What is live lock, deadlock and what is Lock escalation?

2434

ORA-16516: The current state is invalid for the attempted operation.

8820

what are the test cases for ticket vending machine?

4282