Not able to format values on an insert statement without a new line after "VALUES (" (4249358)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Not able to format values on an insert statement without a new line after "VALUES ("
Description

I am trying to format an insert statement and cannot get it to look like the way I want. Here is the closest I could get it in Toad.
      INSERT INTO trans_hrdb.compsaas_jobs_control_detail(
                     compsaas_job_detail_id
                   , compsaas_job_id
                   , request_date)
      VALUES (
                v_compsaas_job_detail_id
              , p_compsaas_job_id
              , p_request_date);
Â
Here is how I want it to look.
Â
      INSERT INTO trans_hrdb.compsaas_jobs_control_detail(
                     compsaas_job_detail_id
                   , compsaas_job_id
                   , request_date)
      VALUES (v_compsaas_job_detail_id
              , p_compsaas_job_id
              , p_request_date);
Resolution

WORKAROUND:
None

STATUS:
Waiting for enhancement request to be implemented in a future version of Toad for SQL Server.
Defect ID

ST72908

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title