[Oracle] Wildcard and Regex solution, explain plan review.
1.Wildcard\n\nSELECT\n    pa.patient_id\n    , pa.patient_name\n    , pa.conditions\nFROM patients pa\nWHERE\n    pa.conditions LIKE \'DIAB1%\'\nOR\n    pa.cond
**1.Wildcard**\n```\nSELECT\n    pa.patient_id\n    , pa.patient_name\n    , pa.conditions\nFROM patients pa\nWHERE\n    pa.conditions LIKE \'DIAB1%\'\nOR\n    pa.conditions LIKE \'% DIAB1%\'\n;\n```\n![image](https://assets.leetcode.com/users/images/e60f4e03-c952-4a65-81f2-83d4e5624bef_1660225907.5812278.png)\n\n**2.Regex**\n```\nSELECT\n    pa.patient_id\n    , pa.patient_name\n    , pa.conditions\nFROM \n    patients pa\nWHERE\n    REGEXP_LIKE(pa.conditions, \'^DIAB1|\\sDIAB1\')\n;\n```\n- `^DIAB1`: conditions begin with DIAB1 (same as LIKE \'DIAB1%\')\n- `|`: OR\n- `\\sDIAB1`: conditions begin with whitespace+DIAB1 (same as LIKE \'% DIAB1%\')\n![image](https://assets.leetcode.com/users/images/db7a4ecd-6fb6-440c-b0d9-fa4962c73afc_1660226010.979697.png)\n\nBoth queries have the same explain plan. Wildcard is more straigh forward, but Regex is more simple.
['Oracle']