Oral sedation is preferable to IV sedation for many patients. People with dental anxiety are also often not big fans of needles. Most people with dental anxiety are also happy with not remembering what went on during the exam or treatment.
Furthermore, oral sedatives for dentistry are regulated by the FDA so you can rest assured that the treatment is safe to use.