SQL Language (MOSC)

MOSC Banner

Unexpected query output..

edited Feb 18, 2010 4:57AM in SQL Language (MOSC) 10 commentsAnswered
 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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center