Home » SQL & PL/SQL » SQL & PL/SQL » How to find LOB format (Oracle 10.2.0.3.0, Windows 2003 Server)
How to find LOB format [message #289897] Wed, 26 December 2007 08:36 Go to next message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hello All,

Does any one have a Querry to find the LOB format, Size (Student/Employee PHOTO) stored in Database.


Thanks & Reg





Re: How to find LOB format [message #289904 is a reply to message #289897] Wed, 26 December 2007 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
DBMS_LOB.GETLENGTH will give you the size of a LOB.

Regards
Michel
Re: How to find LOB format [message #289908 is a reply to message #289897] Wed, 26 December 2007 09:08 Go to previous message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Hello Michel,

Thanks for such a fast reply.

Thanks & Reg

Aslam Khalife
Previous Topic: Copy Table
Next Topic: update the year in the date
Goto Forum:
  


Current Time: Thu Feb 06 20:31:58 CST 2025