How to generate Oracle data dictionary from SQL script
Sure, you can use SQL Developer, or Toad, or a similar IDE to generate a data dictionary from an application. But what if you don't have those applications? Or what if you want a more universal way of generating a data dictionary? Then the following SQL script is for you.
This script will return the schema and table names as well as numerous column properties beyond just the column name. It also includes the column's ordinal position, whether or not it is a part of a primary key / foreign key / unique key, its data type and various length/size/precision components, whether or not it is nullable, and the description.
This short video walks you through downloading the script, executing it, pulling the metadata into an Excel file where it can easily be formatted to look pretty and shared with other team members via email.
------ Chapter Timestamps (click to jump forward): ----------------------------
0:00 - Intro
0:09 - Ever Needed to Troubleshoot What Schema Change Broke Your App?
0:33 - Demo: How to Download the Script
1:24 - Demo: How to Run the Script and Generate the Data Dictionary
2:32 - Demo: The Data Dictionary output in Excel
4:00 - The End
Download:
https://raw.githubusercontent.com/Dat...
Watch related playlist videos:
• Oracle SQL Scripts for Data Analysts
Connect with me on social media:
LinkedIn: / mpiercead576
YouTube: / @dataresearchlabs
GitHub: https://github.com/DataResearchLabs
Subscribe to my YouTube Channel:
/ @dataresearchlabs
Background Music (via YouTube "always free" Audio):
"Rewind" by Ofshane: / @ofshane
#Oracle #datadictionary #autogenerate
In questa pagina del sito puoi guardare il video online How to generate Oracle data dictionary from SQL script della durata di ore minuti seconda in buona qualità , che l'utente ha caricato DataResearchLabs 15 maggio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 2,929 volte e gli è piaciuto 41 spettatori. Buona visione!
