Re: no rows with order by

From: <jernigam_at_kochind.com>
Date: 1 Jul 2005 06:43:07 -0700
Message-ID: <1120225387.445333.313310@g47g2000cwa.googlegroups.com>

Here is the create table statement. The DML is above.

create table POD.PRODUCTION
(

  ENTRY_DATE     DATE not null,
  PLANT_ID       NUMBER not null,
  PRODUCT_ID     NUMBER not null,
  UNIT_ID        NUMBER not null,
  PRODUCTION     NUMBER not null,
  COMMENT_ID     NUMBER default 0 not null,

  CREATE_USER VARCHAR2(20) not null,
  CREATE_DATE DATE not null,
  EFFECTIVE_DATE DATE not null,
  INACTIVE_DATE DATE,
  INACTIVE_USER VARCHAR2(20)
)
tablespace POD_DATA
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 256K
    next 256K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
-- Create/Recreate primary, unique and foreign key constraints alter table POD.PRODUCTION
  add constraint PRODUCTION_PK primary key
(UNIT_ID,PRODUCT_ID,PLANT_ID,ENTRY_DATE,EFFECTIVE_DATE,CREATE_DATE)
  using index
  tablespace POD_DATA
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 256K
    next 256K
    minextents 1
    maxextents unlimited
    pctincrease 0
  );
alter table POD.PRODUCTION
  add constraint PRODUCTION_FK1 foreign key (PLANT_ID)   references POD.PLANT (PLANT_ID) on delete cascade; alter table POD.PRODUCTION
  add constraint PRODUCTION_FK2 foreign key (PRODUCT_ID)   references POD.PRODUCT (PRODUCT_ID) on delete cascade; alter table POD.PRODUCTION
  add constraint PRODUCTION_FK3 foreign key (COMMENT_ID)   references POD.COMMENTS (COMMENT_ID); Received on Fri Jul 01 2005 - 08:43:07 CDT