DRG-10840: CONTAINS predicate including 0 is not supported
by FIRST_ROWS hint



DRG-10840: CONTAINS predicate including 0 is not supported by FIRST_ROWS hint..

Answer / guest

Cause: User attempts to issue a query with CONTAINS
predicate including 0 while giving FIRST_ROWS hint.

Action: remove FIRST_ROWS hint.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

LSX-00331: missing comma

1 Answers  


ORA-33223: (CMOVE03) You cannot move a session-only dimension value.

1 Answers  


ORA-02712: osnpop: malloc failed

1 Answers  


PCC-02444: Invalid combination of descriptor and non-descriptor clauses

1 Answers  


ORA-15071: ASM disk "string" is already being dropped

1 Answers  






ORA-09212: sfwfbmt: error writing to file

1 Answers  


ORA-32772: BIGFILE is invalid option for this type of tablespace

1 Answers  


ORA-01036: illegal variable name/number

1 Answers  


ORA-10579: Can not modify control file during test recovery

1 Answers  


NZE-29247: an unopen toolkit object was used before it was opened

1 Answers  


TNS-01009: service [<listener_name>] : get the service information of the listener

1 Answers  


DRG-13001: sub lexer and multi lexer must have the same owner

1 Answers  


Categories