Re: Generate sql file from Oracle Designer

procman wrote:
> I'm using Oracle Designer to design and maintenance the DB on PC.
> The "real" schema is on the Unix.
> In order to add a new table or edit an exist table, i'm doing the
> following:
> 1. edit a table in the designer.
> 2. generate *.tab, *.con and *.sql files from the designer (on the
> PC).
> 3. Run an internal generator(on the Unix) to generate interface for my
> application, from the *.sql file.
>
> My question is:
> How can I generate *.sql file (with the *.tab/*.con files) from a
> table, and not direct from the designer. I mean, is there any
> interface or API to do that? is there any stand alone executable to
> generate sql file NOT from Oracle Designer?
> I need it to combine steps 2&3 above to single step (wrap them in one
> exe or script).
>
>
> Thanks

The times I used Designer, there also was a .sql, which called all tab, con and other generated stuff in the correct order.
Even better, there's an option to execute the lot from Designer, too. This feature is "new" as of V6.0 (which is around some time now). So, all you have to do, is configure SQL*Net correctly, and execute the generated scripts from within Designer - make sure you connect to the correct instance.

Step 3 is quite unclear to me. What interface? You only maintain a database...
And yes - Designer has a documented API - if you insist on reinventing the (designer generator) wheel...

-- 
Regards,
Frank van Bortel