RE: sql column formatting
- From: raja rao <raja4list@xxxxxxxxx>
- To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 19 Jul 2006 07:47:08 -0700 (PDT)
the sql what i am using is same as you given below.
i will try this option given by you and come back to you.
thanks much for immediate response.
"Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:
v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}
Raj,
Can you show us your sql statement? Also, why not use a column alias in your
select and use that column alias in your format statement?
column patient_name format a37 heading 'Patient_Name'
Select TRIM(replace(PATIENT_NAME,'-',',')) patient_name
From ??
Tom
---------------------------------
This transmission may contain confidential, proprietary, or privileged
information which is intended solely for use by the individual or entity to
whom it is addressed. If you are not the intended recipient, you are hereby
notified that any disclosure, dissemination, copying or distribution of this
transmission or its attachments is strictly prohibited. In addition,
unauthorized access to this transmission may violate federal or State law,
including the Electronic Communications Privacy Act of 1985. If you have
received this transmission in error, please notify the sender immediately by
return e-mail and delete the transmission and its attachments.
---------------------------------
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of raja rao
Sent: Wednesday, July 19, 2006 9:11 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: sql column formatting
Hi All,
Can some one help me in setting the column format.
I have the 2 below commands:
column TRIM(replace(PATIENT_NAME,'-',',')) format a37 heading 'Patient_Name'
column concat(to_char(ADMIT_DT,'MMDDYYYY'),ATTENDING_PHYSICIAN)
format a47 heading 'Date_ofReferring_Phys_Code'
the format is working fine and i'm getting in size a37 and a47 till the
weekend.
last week we did online partitioning of the table. But that was not in
weekend. that was in mid of the week.
after the partitioning also we got 2 successful reports. (with correct
format)
later, the format is not working for us. when we try to query also,
it is showing a65 output. the scripts are not changed.
i am confused why oracle behaves like this. (this is a 9i database on
solaris)
can someone throw some light on this.
Thanks in advance,
Raj
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---------------------------------
Do you Yahoo!?
Next-gen email? Have it all with the all-new Yahoo! Mail Beta.
Other related posts:
