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

2751

i have created ODBC through Data sources and tests completed sucessfully. when i am Trying to connect SQL Server through ODBC (ODBC :Oracle Open Client Adapter for ODBC 2.0.2.15.0 Microsoft SQL Server 09.00.3054) unable to Connect to SQL*Plus: Release 8.0.4.0.0. it is given following error-message . Error: ORA-03121: NO interface driver connected- function not performed.

2816

I would like to if there is any vb script to populate my values in the application.Example i will input the data in two 2 rows a & b.I need script where the data in a or b have to populate in my application if my a = nothing and b = 1 or a = 1 or b = nothing.I would be glab if someone can help me here.

2424

ORA-16626: failed to enable specified object

2229

if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2717

IMP-00064: Definition of LOB was truncated by export

6428

When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.

2530

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

2530

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

1962

hp asking for replication floppy to do reinstall 25254 server assistant

2901

For pH-4 calculation it is subtracted from the previous pH7 buffer value is the same procedure to be followed for calculation of remaining buffers??

1637

IMP-00070: Lob definitions in dump file are inconsistent with database.

1758

Write down the difference between c. Loop and goto statement d. (!0) and (!1) e. (1= =! 1) and (1!=1) f. NULL and !NULL

3829

How to create a program that lists countries capitals when country is entered? (Terribly sorry, I'm a complete novist to coding with C, am looking for inspiration and general tips on how to code and create this program.)

1446

A sample program using data structure? what is file handling?

3388