| 1460 | return select._fetch_clause |
| 1461 | |
| 1462 | def fetch_clause( |
| 1463 | self, |
| 1464 | select, |
| 1465 | fetch_clause=None, |
| 1466 | require_offset=False, |
| 1467 | use_literal_execute_for_simple_int=False, |
| 1468 | **kw, |
| 1469 | ): |
| 1470 | text = super().fetch_clause( |
| 1471 | select, |
| 1472 | fetch_clause=fetch_clause, |
| 1473 | require_offset=require_offset, |
| 1474 | use_literal_execute_for_simple_int=( |
| 1475 | use_literal_execute_for_simple_int |
| 1476 | ), |
| 1477 | **kw, |
| 1478 | ) |
| 1479 | |
| 1480 | if select.dialect_options["oracle"]["fetch_approximate"]: |
| 1481 | text = re.sub("FETCH FIRST", "FETCH APPROX FIRST", text) |
| 1482 | |
| 1483 | return text |
| 1484 | |
| 1485 | def translate_select_structure(self, select_stmt, **kwargs): |
| 1486 | select = select_stmt |