Return
-
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