Need to set format for this output

Name
--------------------------------------------------------------------------------
Last Submitted
------------------------
Requestor
--------------------------------------------------------------------------------
Next Scheduled Run         INTERVAL UNIT
------------------------ ---------- ------------------------------
From Previous CCR              S Print to                           Copies
------------------------------ - ------------------------------ ----------
    Req id Parent Req ID
---------- -------------
STATUS
--------------------------------------------------------------------------------
CCR Parameters
--------------------------------------------------------------------------------
 Normal
columbus131Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
set lines 100000
set trimspool on
set pages 0
set feedback off
col somecolumnname format a500
--the individual columns need to be set to their max values.
0
 
sdstuberCommented:
are you looking for a sql*plus line length limit ?

if so...

set linesize 80
0
 
slightwv (䄆 Netminder) Commented:
What 'format' do you want and from what product?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
columbus131Author Commented:
SELECT
  user_concurrent_program_name "Name",
  to_char(request_date, 'DD-MON-RR HH24:MI:SS') "Last Submitted",
  u.user_name "Requestor",
  to_char(requested_start_date, 'DD-MON-RR HH24:MI:SS') "Next Scheduled Run",
  fcr.resubmit_interval Interval,
  fcr.resubmit_interval_unit_code Unit,
  fcr.resubmit_interval_type_code "From Previous CCR",
  fcr.save_output_flag "Save Output Files",
  fcr.printer "Print to",
  fcr.number_of_copies "Copies",
  request_id "Req id",
  fcr.parent_request_id "Parent Req ID",
  nvl(meaning, 'UNKNOWN') Status,
  fcr.ARGUMENT_TEXT "CCR Parameters"
FROM
  fnd_concurrent_requests fcr,
  fnd_lookups fl,
  fnd_concurrent_programs_vl fcpv,
  fnd_user u
WHERE
  phase_code = 'P' AND
  (fcr.requested_start_date >= sysdate OR
    status_code = 'P') AND
  LOOKUP_TYPE = 'CP_STATUS_CODE' AND
  lookup_code = status_code AND
  fcr.concurrent_program_id = fcpv.concurrent_program_id AND
  fcr.program_application_id = fcpv.application_id and
  u.user_id=fcr.requested_by
ORDER BY
  request_date,
  request_id;
0
 
slightwv (䄆 Netminder) Commented:
That doesn't tell us what format you want the output in or what product/program is to generate it.
0
 
columbus131Author Commented:
I need to spool this and sent i need
to know
what colsize
linesize
pages
i need to set for this query
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.