SQL> select a.action_cd
  2  from
  3  ofsa_construct_actions a
  4  where exists(select 'TUNE' from ofsa_construct_actions where a.construct_cd = 250.00000 );

 ACTION_CD                                                                      
----------                                                                      
        10                                                                      
        20                                                                      
        30                                                                      
        40                                                                      
        50                                                                      


Execution Plan
----------------------------------------------------------                      
                                                                                
------------------------------------------------------------------------------- 
| Id  | Operation         | Name                 | Rows  | Bytes | Cost (%CPU)| 
------------------------------------------------------------------------------- 
|   0 | SELECT STATEMENT  |                      |     3 |    18 |    69   (0)| 
|   1 |  INDEX FULL SCAN  | CONSTRUCT_ACTIONS_PK |    11 |    66 |     1   (0)| 
|   2 |   FILTER          |                      |       |       |            | 
|   3 |    INDEX FULL SCAN| CONSTRUCT_ACTIONS_PK |     1 |       |     1   (0)| 
------------------------------------------------------------------------------- 
                                                                                
Note                                                                            
-----                                                                           
   - 'PLAN_TABLE' is old version                                                


Statistics
----------------------------------------------------------                      
          0  recursive calls                                                    
          0  db block gets                                                      
          3  consistent gets                                                    
          0  physical reads                                                     
          0  redo size                                                          
        475  bytes sent via SQL*Net to client                                   
        381  bytes received via SQL*Net from client                             
          2  SQL*Net roundtrips to/from client                                  
          0  sorts (memory)                                                     
          0  sorts (disk)                                                       
          5  rows processed                                                     

SQL> select distinct ofsa_construct_actions.action_cd
  2  from ofsa_construct_actions
  3  where ofsa_construct_actions.construct_cd = 250.00000
  4  ;

 ACTION_CD                                                                      
----------                                                                      
        10                                                                      
        20                                                                      
        30                                                                      
        40                                                                      
        50                                                                      


Execution Plan
----------------------------------------------------------                      
                                                                                
--------------------------------------------------------------------------------
| Id  | Operation          | Name                 | Rows  | Bytes | Cost (%CPU)|
--------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |                      |     4 |    24 |     2  (50)|
|   1 |  SORT UNIQUE NOSORT|                      |     4 |    24 |     2  (50)|
|   2 |   INDEX FULL SCAN  | CONSTRUCT_ACTIONS_PK |     5 |    30 |     1   (0)|
--------------------------------------------------------------------------------
                                                                                
Note                                                                            
-----                                                                           
   - 'PLAN_TABLE' is old version                                                


Statistics
----------------------------------------------------------                      
          1  recursive calls                                                    
          0  db block gets                                                      
          2  consistent gets                                                    
          0  physical reads                                                     
          0  redo size                                                          
        475  bytes sent via SQL*Net to client                                   
        381  bytes received via SQL*Net from client                             
          2  SQL*Net roundtrips to/from client                                  
          0  sorts (memory)                                                     
          0  sorts (disk)                                                       
          5  rows processed                                                     

SQL> spool off