Hi,
What is the difference between the Oracle Data Dictionary and MySQL's INFORMATION_SCHEMA?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jimmy UnderwoodPosted Jan 17, 2012, 2:18 PM
Arjun PanwarPosted Dec 27, 2011, 2:08 PM
Oracle and MySQL provide metadata information in tables. At the detail level, though, there are many differences because Oracle and MySQL use different table names and column names for that metadata information. There is more similarity with DB2 and SQL Server, which also has an INFORMATION_SCHEMA as in the SQL standard.
Datta KharadPosted Dec 19, 2011, 12:44 AM
You can refer this link..
http://www.mysql-rdbms.info/archives/what-is-the-difference-between-the-oracle-data-dictionary-and-mysql-information_schema.html