sql column formatting
- From: raja rao <raja4list@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 19 Jul 2006 06:10:48 -0700 (PDT)
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
Other related posts:
