Home » SQL & PL/SQL » SQL & PL/SQL » identify table associated with a blob.
identify table associated with a blob. [message #275206] Thu, 18 October 2007 15:40 Go to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

hello,
can you please help me how do we identify the table associated with the blob name .. ?

Thanks.
Re: identify table associated with a blob. [message #275221 is a reply to message #275206] Thu, 18 October 2007 20:25 Go to previous message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Not sure, what you mean with 'associated'.

Views USER_LOBS / ALL_LOBS / DBA_LOBS contain evidence of all LOBs containde intables owned by the current user / accesible to the current user / in the database.
See Reference manual to find more details about these views.

If this is not, what you want, elaborate your requirement more precisely.
Previous Topic: Comparison Operator from column
Next Topic: unix in Pl/sql blocks
Goto Forum:
  


Current Time: Fri Dec 09 21:12:58 CST 2016

Total time taken to generate the page: 0.10765 seconds