OraFAQ Forum: Server Administration » Simple Where Condition is not working

Home » RDBMS Server » Server Administration » Simple Where Condition is not working

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

Simple Where Condition is not working [message #54227]

Wed, 06 November 2002 00:35

Zahid Rahim
Messages: 31
Registered: April 2002

Member

Hello All,
i created a table taking data from another user with the syntax
create table tbl1 as select * from newuser.tbl1;
when i am trying to fetch the records using simple where condition on varchar2 column it returns the message no rows selected.
waiting for reply very badly,
Zahid

Report message to a moderator

Re: Simple Where Condition is not working [message #54236 is a reply to message #54227]

Wed, 06 November 2002 05:42

B
Messages: 327
Registered: August 1999

Senior Member

cause U create a condition tthat return no rows...
change Ur where clause

Report message to a moderator

Previous Topic:	Urgent DBA
Next Topic:	ORA-02095

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 15:35:53 CST 2024