OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » where clause

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

where clause [message #273551]

Wed, 10 October 2007 21:28

maxim9
Messages: 3
Registered: October 2007

Junior Member

Hello All, how to compare names in where clause.?

l_name varchar2(50)

---

CURSOR
....

OPEN
...

SELECT
..
where name = l_name

it give no data found error.

procedure compiles but failes on execution.

it works

where name = 'Tom'

so how to compare?

Thanks,Maxim

Report message to a moderator

Re: where clause [message #273552 is a reply to message #273551]

Wed, 10 October 2007 21:33

maxim9
Messages: 3
Registered: October 2007

Junior Member

I mean is there, can i use quote? to_char..etc

Thanks in advance

Maximus

Report message to a moderator

Re: where clause [message #273553 is a reply to message #273551]

Wed, 10 October 2007 21:35

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW posting guidelines above.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm

You can find many fine coding examples at http://asktom.oracle.com

Report message to a moderator

Re: where clause [message #273557 is a reply to message #273553]

Wed, 10 October 2007 22:14

maxim9
Messages: 3
Registered: October 2007

Junior Member

Thanks for the reply. I am new here. Can you help? I have to equate t.name = l_name in a where condition. but it gives no data found error. I used to_char, " " also. Did not work

Thanks,Maximus

Report message to a moderator

Re: where clause [message #273561 is a reply to message #273551]

Wed, 10 October 2007 22:22

muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh

Senior Member

Quote:

l_name varchar2(50)

---

CURSOR
....

OPEN
...

SELECT
..
where name = l_name

Did you assign "Tom" to variable l_name.
If possible post your code, we will then go through the code.

Report message to a moderator

Previous Topic:	Errors (ORA-03113, ORA-03114) for trigger and deref()
Next Topic:	Outer Join Question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 01:43:02 CST 2025