<div>
Beat da cancer......Yes and Yes. <br />
<br />
I thank you for that data modeler that looks promising. I also thank you for the tips on the programming. <br />
<br />
That tool I spoke of was amazing to me at least because it helped me get at the data without any &quot;database models&quot;....where it shows all the tables in the database and links between them. I always thought that was called the &quot;Database Schema.&quot; SQL Grep was a set and forget. It could run through a large database from anywhere from a minute to 12-15 minutes and since DB's can be so complex having the same record in multiple tables it was always helpful to see them all so I can figure out which one would be more efficient to use. <br />
<br />
Again thank you. Now I just need to figure out how to build this concept in what looks like I will need JAVA for the GUI, Python or R &nbsp;and finally XML because it sounds like you are familiar with. I may be posting &nbsp;more questions on this which may teeter between Database and Programming forums.
</div>


<div>
<div class="content wysiwyg-content">
I need to reverse engineer an Oracle database with no access to the DB schema or how the table relationships work. The software manufacturer will not allow anyone to know that and pressures its customers to purchase a very expensive report writer consultant that most customers would rather circumvent. <br />
<br />
This expert <a href="https://www.experts-exchange.com/questions/27109431/How-can-I-search-an-Oracle-Database-effectively-looking-for-records.html?anchorAnswerId=36018292#a36018292" rel="ugc">comment</a> shows information about Views that are available for the Oracle tool PLSQL Developer. &quot;The views to get tables, columns and data types are readily available. &nbsp;Then you would just need to loop through them to build the SQL to select out the data.&quot;<br />
<br />
Does anyone know what he is talking about and where I might find the code for this? <br />
I assume I plug them into PLSQL and run it against the DB. <br />
Is there a site with all this kind of info?
</div>
</div>


I need to reverse engineer an Oracle database with no access to the DB schema or how the table relationships work. The software manufacturer will not allow anyone to know that and pressures its customers to purchase a very expensive report writer consultant that most customers would rather circumvent. 

This expert comment (https://www.experts-exchange.com/questions/27109431/How-can-I-search-an-Oracle-Database-effectively-looking-for-records.html?anchorAnswerId=36018292#a36018292) shows information about Views that are available for the Oracle tool PLSQL Developer. "The views to get tables, columns and data types are readily available.  Then you would just need to loop through them to build the SQL to select out the data."

Does anyone know what he is talking about and where I might find the code for this? 
I assume I plug them into PLSQL and run it against the DB. 
Is there a site with all this kind of info?

PLSQL views that can help identify a specific record the type, the field and table names in a large Oracle DB. With NO Schema or knowledge of which table to start with?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.