Wednesday, July 20, 2016

DDL from a query (Oracle)

All the good db clients like SQL developer, TOAD and so on are good at showing you the DDLs for the tables your are working on, but sometimes these tools are not available at the current environament you have. i.e ATG JDBC Browser:

So you can get the DDL with a Query for any DB object, here is how to do it:

And this is how it looks like the output on JDBC browser which is where I needed to use it:

I found this here
Post a Comment