fork download
  1. BEGIN{PROCINFO["sorted_in"] = "@ind_str_asc"}
  2. /^\(/{f=1}
  3. /^\)/{f=0
  4. for (i in a)
  5. print a[i]
  6. delete a}
  7. f{a[$1]=$0}
  8. !f
  9.  
Success #stdin #stdout 0.01s 5436KB
stdin
CREATE TABLE BBBBBB
(
   ID bigint NOT NULL
   NAME varchar(50)
   CURRENCY varchar(3)
   SYS_START timestamp NOT NULL
   SYS_END timestamp NOT NULL
   TS_ID timestamp NOT NULL
   EXPORT int
)

CREATE TABLE AA
(
   ID bigint NOT NULL
   SYS_START timestamp NOT NULL
   SYS_END timestamp NOT NULL
   TS_ID timestamp NOT NULL
   NAME varchar(100) NOT NULL
)
stdout
CREATE TABLE BBBBBB
(
   CURRENCY varchar(3)
   EXPORT int
   ID bigint NOT NULL
   NAME varchar(50)
   SYS_END timestamp NOT NULL
   SYS_START timestamp NOT NULL
   TS_ID timestamp NOT NULL
)

CREATE TABLE AA
(
   ID bigint NOT NULL
   NAME varchar(100) NOT NULL
   SYS_END timestamp NOT NULL
   SYS_START timestamp NOT NULL
   TS_ID timestamp NOT NULL
)