Home » RDBMS Server » Server Administration » Simple Where Condition is not working
Simple Where Condition is not working [message #54227] Wed, 06 November 2002 00:35 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 16:45:14 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.