title: Get max(length(column)) for all columns in an Oracle table
body: <p>I need to get the maximum length of data per each column in a bunch of tables. I'm okay with doing each table individually but I'm looking for a way to loop through all the columns in a table at least.</p>
  
  <p>I'm currently using the below query to get max of each column-</p>
  
  <pre><code>select max(length(exampleColumnName)) 
  from exampleSchema.exampleTableName;
  </code></pre>
  
  <p>I'm basically replacing the exampleColumnName with each column in a table.
  I've already went through 3-4 threads but none of them were working for me either because they weren't for Oracle or they had more details that I required (and I couldn't pick the part I needed). </p>
  
  <p>I'd prefer to have it in SQL than in PLSQL as I don't have any create privileges and won't be able to create any PLSQL objects.</p>