Also, I have a lot of tables in my schema, and I want to search only tables that contain specific fields (example: NAME). How do I do this? Thanks.
To search tables, use the INFORMATION_SCHEMA views.
Dig deeper on Oracle database design and architecture
Related Q&A from Rudy Limeback, SQL Consultant, r937.com
Read SQL expert Rudy Limeback's advice for counting combinations in a table with SQL's GROUP BY clausecontinue reading
Read an example of an SQL case expression from our SQL expert Rudy Limeback.continue reading
Read about the Mimer Validator, a tool used to verify your SQL code, in this tip from SQL expert Rudy Limeback.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.