| How to use LIKE operator in develoepr 10g [message #271152] |
Sun, 30 September 2007 02:49  |
dbhossain
Messages: 155
Registered: August 2007
Location: Dhaka
|
Senior Member |
 
|
|
Dear Experts,
i wrote the following code, its executing and compiling
but no output found:
-----------------------------------------------
declare
cursor c is
select empno,ename,sal,job from emp
where UPPER(job) like 'UPPER(:emp.jname)%';
begin
---clear_block;
go_block('emp');
open c;
clear_block;
loop
fetch c into :emp.empno,:emp.ename,:emp.sal,:emp.JOB;
next_record;
exit when c%notfound;
end loop;
close c;
--EXCEPTION
-- WHEN NO_DATA_FOUND THEN
--MESSAGE('HELLO');
--first_record;
end;
-------------------------------------------------
***** My problem is the above code is executing
without any error but i am not getting any output.
is my Code Okay, to use the LIKE Operator in the above
code?
Note: as Example if i type PR instead of PRESIDENT
to view the data of employees who is President.
my query finds no output. but the PRESIDENT job is exists
in my emp table.
please help me.
Best Regards,
Kamal Hossain
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
