Home » SQL & PL/SQL » SQL & PL/SQL » Help for getting information where external table used in database (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)
Help for getting information where external table used in database [message #667192] Thu, 14 December 2017 01:18 Go to next message
msol25
Messages: 396
Registered: June 2011
Senior Member
Hi Experts,

please help for getting all the objects using external table: "ext_tab_docomo" in the database.
Re: Help for getting information where external table used in database [message #667194 is a reply to message #667192] Thu, 14 December 2017 01:28 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at the results of

select * from dba_source where upper (text) like '%EXT_TAB_DOCOMO%'
Re: Help for getting information where external table used in database [message #667195 is a reply to message #667194] Thu, 14 December 2017 01:36 Go to previous message
msol25
Messages: 396
Registered: June 2011
Senior Member
Thanks Littlefoot.
Previous Topic: Retrieve column names with aliases
Next Topic: Need to Retrieve data from JSON file in Oracle sql select query
Goto Forum:
  


Current Time: Fri Mar 29 00:23:39 CDT 2024