SQLDeveloper Formatting
Hi,I have a Customer who is using the latest version of SQLDeveloper. The issue is that the formatting does not work. I just raised a Bug on this. However, just wanted to know if there is something that I am missing out.
1. Copy paste the Query in SQL Worksheet
OPEN p_ncmr_email_cur FOR SELECT t409.c409_ncmr_id ncmrid , get_vendor_name (t409.c301_vendor_id) vname , TO_CHAR (
t409.c409_created_date , 'mm/dd/yyyy') cdate FROM t409_ncmr t409 , t408_dhr t408 WHERE t409.c205_part_number_id =
p_partnum AND t409.c408_dhr_id = t408.c408_dhr_id AND t408.c408_void_fl IS NULL AND t409.c409_void_fl IS NULL
1. Copy paste the Query in SQL Worksheet
OPEN p_ncmr_email_cur FOR SELECT t409.c409_ncmr_id ncmrid , get_vendor_name (t409.c301_vendor_id) vname , TO_CHAR (
t409.c409_created_date , 'mm/dd/yyyy') cdate FROM t409_ncmr t409 , t408_dhr t408 WHERE t409.c205_part_number_id =
p_partnum AND t409.c408_dhr_id = t408.c408_dhr_id AND t408.c408_void_fl IS NULL AND t409.c409_void_fl IS NULL
0