Home » SQL & PL/SQL » SQL & PL/SQL » Simple updation failed ? Reason ? (Oracle 10.2)
Simple updation failed ? Reason ? [message #582681] Sun, 21 April 2013 09:19 Go to next message
bluetooth420
Messages: 67
Registered: November 2011
Member
Hi

I am failed to understand the following. can anyone guide me.

There is a simple table prod having a column crlf.

i did the following
Quote:

SQL> update prod set crlf=null;

716 rows updated.

SQL> commit;

Commit complete.

SQL> select * from prod where crlf=null;

no rows selected



why NO row selected against last query????


Kindly tell me what is wrong?
Re: Simple updation failed ? Reason ? [message #582682 is a reply to message #582681] Sun, 21 April 2013 09:22 Go to previous messageGo to next message
bluetooth420
Messages: 67
Registered: November 2011
Member
ohhh
i got the reason

it should be CRLF is null
Re: Simple updation failed ? Reason ? [message #582683 is a reply to message #582682] Sun, 21 April 2013 09:23 Go to previous messageGo to next message
bluetooth420
Messages: 67
Registered: November 2011
Member
i think i must stop working as i am suffering with fever. It really making my efficieny down Sad
Re: Simple updation failed ? Reason ? [message #582684 is a reply to message #582683] Sun, 21 April 2013 10:35 Go to previous message
Michel Cadot
Messages: 57613
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Will I be a little be sarcastic... No, it's a sunny spring day, you're lucky. Very Happy

Regards
Michel

[Updated on: Sun, 21 April 2013 10:36]

Report message to a moderator

Previous Topic: Separate Index and tables in two different tablespace
Next Topic: how to find last or latest inserted row.?
Goto Forum:
  


Current Time: Sun Apr 20 09:58:45 CDT 2014

Total time taken to generate the page: 0.08857 seconds