Unexpected query output..
Hi,
Today i was doing some task , when i encountered a result from a query which is completely unexpected. Can some one let me know how to fix it and what wrong with the query? below is the details..
Table details
------------------
SQL> desc CCTR_SVCRQ
Name Null? Type
----------------------------------------- -------- ----------------------------
SVCRQ_SYS_I NOT NULL VARCHAR2(15)
SVCRQ_SEQ_I NOT NULL NUMBER(8)
Index details ( the index is a composite pk index with SVCRQ_SEQ_I at position 2 and SVCRQ_SYS_I position 1 )
------------------------------------------------------------------------------------
SQL> select INDEX_NAME,TABLE_NAME,COLUMN_NAME from dba_ind_columns where TABLE_NAME='CCTR_SVCRQ';
Today i was doing some task , when i encountered a result from a query which is completely unexpected. Can some one let me know how to fix it and what wrong with the query? below is the details..
Table details
------------------
SQL> desc CCTR_SVCRQ
Name Null? Type
----------------------------------------- -------- ----------------------------
SVCRQ_SYS_I NOT NULL VARCHAR2(15)
SVCRQ_SEQ_I NOT NULL NUMBER(8)
Index details ( the index is a composite pk index with SVCRQ_SEQ_I at position 2 and SVCRQ_SYS_I position 1 )
------------------------------------------------------------------------------------
SQL> select INDEX_NAME,TABLE_NAME,COLUMN_NAME from dba_ind_columns where TABLE_NAME='CCTR_SVCRQ';
0