Generate sql file from Oracle Designer

jhking · *nix forums beginner Joined: 10 Feb 2005 Posts: 6

procman wrote:

Frank van Bortel · *nix forums Guru Joined: 19 Apr 2005 Posts: 804

procman wrote:

procman · *nix forums beginner Joined: 10 Feb 2005 Posts: 1

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

Google