Open GoogleCodeExporter opened 9 years ago
The platform is Oracle
Original comment by eddybu...@gmail.com
on 20 Sep 2010 at 10:04
Hello,
Could you please send me the table schema for this Oracle Table (without data).
Thanks
-Blake Niemyjski
Original comment by bniemyjski
on 21 Sep 2010 at 12:02
create table TBL_CUENTA
(
ID NUMBER(15) not null,
NROCTA VARCHAR2(10) not null,
SALDO NUMBER(9,2) not null,
IDCLIENTE VARCHAR2(13) not null
)
-- Create/Recreate primary, unique and foreign key constraints
alter table TBL_CUENTA
add constraint TBL_CUENTA_PK primary key (ID)
using index
tablespace TBSFITDESA
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table TBL_CUENTA
add constraint TBL_CUENTA_CLIENTE_FK foreign key (IDCLIENTE)
references TBL_PERSONA (ID);
create table TBL_PERSONA
(
ID VARCHAR2(13) not null,
NOMBRES VARCHAR2(50) not null,
EDAD LONG,
FECHAEMISION DATE
)
Original comment by eddybu...@gmail.com
on 21 Sep 2010 at 2:20
Hello,
Thank you
Thanks
-Blake Niemyjski
Original comment by bniemyjski
on 21 Sep 2010 at 8:47
Original issue reported on code.google.com by
eddybu...@gmail.com
on 20 Sep 2010 at 10:01