Book a Demo

Author Topic: generate DDL, java to oracle Database  (Read 2230 times)

suayi

  • EA Novice
  • *
  • Posts: 2
  • Karma: +0/-0
    • View Profile
generate DDL, java to oracle Database
« on: September 09, 2008, 12:13:18 am »
Hi,

I'm trying to generate DDL from a java code.

Someone knows how to change object types (generated by default) to simple oracle types??

for example, I've :

CREATE TABLE CentroExamen
(
      centrosFormador   Collection<CentroFormador>,
      idCentroExamen    LONG
)
;

and I wish:

CREATE TABLE CentroExamen
(
      centrosFormador   integer,
      idCentroExamen    LONG
)
;
ALTER TABLE CentroExamen ADD CONSTRAINT FK_CentroExamen_centrosFormador
      FOREIGN KEY (centrosFormador) REFERENCES CentrosFormador  (centrosFormadorID)
;