One of the more popular features in SQL Developer is the ability to generate the CREATE DDL script for any object. If you open an object editor, the SQL page shows this script.
5.Run Xentry Developer which you have downloaded from above link. Enter the HW-ID, AppID, Start date and Finish date which had got from StarKey manager (HW-ID, AppID, Start date and Finish date must be as same as they are in StarKey manager), then click Generate.
Now, what many of you don’t realize is that the way this code can be generated is configurable.
The requests I am most frequently asked to demo here are:
- No storage parameters
- No schema notation
- Show me the grants!
Actually, there’s another request that I won’t go into detail here, but the quoted identifiers when they are not necessary…that’s also on MY wish list ?
How to Configure the DDL Generation
Open the preferences. Go to the database page, then the utilities. And then, go to the Export page.
From there, the very top of that preference panel specifies how the DDL will be generated when you use features like the object editors, the Export wizard, and the Cart.
Once I make my changes, I can just refresh my SQL page on my table editor.
And voila, my code is ready:
But I Need Even More Options
Then might I suggest the Data Modeler?
Add your object(s) to a relational model, and then generate the DDL.
You have a few more options here. And you can specify if you want those darn quoted identifiers or not, e.g. CREATE OR REPLACE TABLE X vs CREATE OR REPLACE TABLE “X”.
One last thing.
If you don’t open the Physical model, the DDL generated won’t include the information from there. For example the triggers and tablespaces won’t be there. So you have even more flexibility.