Link to home
Start Free TrialLog in
Avatar of RUA Volunteer2?
RUA Volunteer2?Flag for United States of America

asked on

How can I find specific records in a large database if...?

How can I find specific records in a large database if...?
I do not have access to any DB schema.
I do not know even which (1000) table(s) to choose.
I do not know what any of the relationships are in the tables.

"There used to be this great tool called SQL Grep that you could plug in any value integer, string, date, boolean etc.
The tool would search a large database in a few minutes identifying and determining what Table and Field the record is in.
Thus giving the ability to reverse engineer the tables and find all the relationships but that products owner shut all the products down closing the entire company.
Not sure why."

Is there a tool that can do this. This question was asked 7 years ago but the only tool was SQL Grep at the time.
I do not even know what classification this product is or what to search Google for? Would it be called a data search tool?
No idea...
SOLUTION
Avatar of Olaf Doschke
Olaf Doschke
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RUA Volunteer2?

ASKER

Dear Olaf,
Thank you for the education. I am very coachable and can either lead or follow on command. Something I learned long ago. My problem is so many companies usually smaller to mid sized have this problem of an application whereby the software manufacturer does not allow access to the proprietary "information schema" and try to impose their team on a project. Anywhere from $1500-$2500 a day is not unusual. Some consultants staying for months. To a small business or even mid-sized can put a serious strain on a budget. That is why so many clients go overseas to source foreign labor. I found a niche with the SQL Grep where with my limited knowledge at the time of SQL I could query a db quickly. Usually after office hours never impacting performance. This giving a lower cost solution to clients keeping me employed in my own country which is nice when you are too old to dig ditches or shovel manure as I did growing up on a farm. So to answer some of the questions:

But you can make a connection to the database, can't you? I can make a connection to the live database. I am working with Tableau so I have to be careful during the day because it is in use and I need to make extracts once I find the correct tables.
What product are we talking about? Oracle (PLSQL hints on that) It is Oracle DB utilizing PLSQL. The product is a cost analysis and estimating tool that is used in the housing industry.

You can always read a schema. There are four tables that have SCHEMA in them and they have nothing but settings information in them looks like they are used for export.

plsql offers INFORMATION_SCHEMA tables with data about the tables, go for https://docs.oracle.com/cd/E19078-01/mysql/mysql-refman-5.0/information-schema.html    I could not find any tables that have the INFORMATION_SCHEMA in them? Oh I wish I had.

NETMINDER unfortunately no it is not a duplicate. I was asking there if anyone knows of a product out there like SQL Grep that does what it did. Which helps a guy like me not have to spend hours hunting for a table and field out of 1000's of tables for a record that is unique. I would not say I am lazy just inexperienced and Grep helped me keep costs and time low for customers. It was great going to an application and look at a record in the GUI and say where is that located. Click a button and say ' Hell there it is then figure out how to connect the dots? Maybe there is a super easy way to search an entire database in PLSQL like....feel free to correct me....
Select *
From All Tables
Where All String Fields that contain "12345678"
as an example

 Since there are so many proprietary products out there with poor designs and no documentation, table definitions or linking diagrams. It really made that need easy to attain. However if someone can show me how to create that in PLSQL I am all ears???
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I got a lot of clarity in those statements so thank you very much for all the expertise and help. I now understand what PLSQL means. I always thought it was more of a brand of SQL. Procedural Language Stored Procedures and functions. I do actually know what a stored procedure is. I typically work on the read only side of the data for reports and visualizations and have been wanting to learn more about the database side of things too help clients who do not have the staff for it. I typically only have to do small simple things and I see the need for more knowledge.....don't we all need more knowledge. I wish I had the brains to cure cancer right and a few other diseases right now.

So with that said thank you very much for all this help. If you have any final advice on where I might go to learn as much more about database manipulation or where I might start? I know how to pull a record from a single table, filter, sort and simple stuff like that. Any programs courses that might help get me up to speed faster?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

>>Any programs courses that might help get me up to speed faster?

The old system paradigm:  Good, Fast, Cheap.  Pick two.  You will NEVER get all three!

Fast and Good (well, decent): Oracle Education.  Learning Tree is OK as well.

Cheap and Good:  Oracle Documentation.  If you are new, start with the Architecture Guide.

Cheap and Fast:  I really have nothing for this combo since I would never recommend it.