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
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

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

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
Messages: 1848
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: Thu Aug 17 04:58:36 CDT 2017

Total time taken to generate the page: 0.16821 seconds