--------------------------------------------------------
--  DDL for Table DUMMY_TABLE
--------------------------------------------------------

  CREATE TABLE "EWDGS_ESM_ECM_MSDB_01"."DUMMY_TABLE" 
  (	 "DUMMY_TABLE_ID" NUMBER(15,0), 
     "TEXT" CLOB
  );
--------------------------------------------------------
--  DDL for Index DUMMY_TABLE_IDX
--------------------------------------------------------

  CREATE UNIQUE INDEX "EWDGS_ESM_ECM_MSDB_01"."DUMMY_TABLE_IDX" ON "EWDGS_ESM_ECM_MSDB_01"."DUMMY_TABLE" ("DUMMY_TABLE_ID");
--------------------------------------------------------
--  Constraints for Table DUMMY_TABLE
--------------------------------------------------------

  ALTER TABLE "EWDGS_ESM_ECM_MSDB_01"."DUMMY_TABLE" ADD CONSTRAINT "DUMMY_TABLE_PK" PRIMARY KEY ("DUMMY_TABLE_ID");
 
  ALTER TABLE "EWDGS_ESM_ECM_MSDB_01"."DUMMY_TABLE" MODIFY ("DUMMY_TABLE_ID" NOT NULL ENABLE);
  
  
--  SELECT statement taken from QOCIDriver::primaryIndex(const QString& tablename) in qsqloci.cpp
--  returns no rows
SELECT * 
FROM  (
      select b.column_name, b.index_name, a.table_name, a.owner 
      from all_constraints a, all_ind_columns b 
      where a.constraint_type='P' 
      and b.index_name = a.constraint_name
      and b.index_owner = a.owner
      ) all_results
WHERE all_results.table_name = 'DUMMY_TABLE';

--  Adapted SQL statement (returns a row)
SELECT * 
FROM  (
      select b.column_name, b.index_name, a.table_name, a.owner 
      from all_constraints a, all_ind_columns b 
      where a.constraint_type='P' 
      and b.index_name = a.index_name
      and b.index_owner = a.owner
      ) all_results
WHERE all_results.table_name = 'DUMMY_TABLE';