Oracle Database Discussions

Hi all

Please tell me what is the correct syntax for using hints

1 . select /*+ index (employees emp_dept_idx) +/ employee_id, department_id from employees where department_id > 10;

2. select /*+ index (mytab name_idx) */ id from mytab where name <> 'HARRY'

3. select /*+ index_combine(e emp_manager_ix emp_department_ix) */ * from employees e where manager_id = 110 or department_id=120;

Please specify it if all the above syntax are valid in which case these are valid.

thanks in advance