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

I worked with $message and $$message, Bt its not working?..

2240

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

2249

IMG-02003: 2FF03 - incorrect color histogram feature specification

1716

pleasesend which type of the books to indian banks clerks& what is topics pleases mailme

2348

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

6753

well i dont have toefl and gre scor all that stuff, and i have 7 backlogs, tell me the chances of getting the visa.

2508

Jetking is C C

2679

hai i got one error i,e http status 404 error what is ds why ds is comming

2598

When i am connect database through toad,one error occured. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor. plz help me thanks advance.............

2808

When I look for mannual enry of any of the command in Unix, such as #man ls, I get a message "Reformatting entry. Wait..." and control comes to a next command prompt. what is the problem?

2467

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

1940

what is the instrument that used in Mechanical Energy??

2686

Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??

1688

Sir, I apply sbi clerk exams(07/09/09)But I did a mistake to enter my date of birth(correct 04.01.1985 / wrong 04.01.1984).please give me suggestions please. Thanking you, Bhushan.B

2136