Home » SQL & PL/SQL » SQL & PL/SQL » Negative values in LOB
Negative values in LOB [message #441328] Sat, 30 January 2010 22:57 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi ALL,

Can we use Negative values in BLOB and CLOB.

Please help me
Thanks
Ramesh
Re: Negative values in LOB [message #441333 is a reply to message #441328] Sat, 30 January 2010 23:12 Go to previous messageGo to next message
BlackSwan
Messages: 24915
Registered: January 2009
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>Can we use Negative values in BLOB and CLOB.

We? I can. I can't answer for you.
Re: Negative values in LOB [message #441351 is a reply to message #441328] Sun, 31 January 2010 00:07 Go to previous messageGo to next message
flyboy
Messages: 1831
Registered: November 2006
Senior Member
ramesh55.sse wrote on Sun, 31 January 2010 05:57
Can we use Negative values in BLOB and CLOB.

BLOB stores binary data. CLOB stores character data.

So, your question makes no sense to me. Or are you aware of any negative binary/character value? Or is it just some kind of interview question?
Re: Negative values in LOB [message #441488 is a reply to message #441351] Mon, 01 February 2010 07:06 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
It is an Interview Question.
Re: Negative values in LOB [message #441489 is a reply to message #441488] Mon, 01 February 2010 07:07 Go to previous message
Michel Cadot
Messages: 63818
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So you have the answer: it is meaningless.

Regards
Michel
Previous Topic: QUERY to get balances of running total
Next Topic: dbms_lob.converttoblob
Goto Forum:
  


Current Time: Sat Oct 01 09:13:27 CDT 2016

Total time taken to generate the page: 0.07983 seconds