| How to get length of column data in oracle form [message #284116] |
Wed, 28 November 2007 23:41  |
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
|
Member |
|
|
Dear How i can got Length of column data on Oracle developer 6i.
..........................
I Know in SQL
Select length(XYZXYZXYZ) from ZZZ;
but it is not work in developer form level function.
|
|
|
|
|
|
| Re: How to get length of column data in oracle form [message #284131 is a reply to message #284116] |
Thu, 29 November 2007 00:07  |
ziauldba
Messages: 55
Registered: January 2007
Location: Bangladesh
|
Member |
|
|
Dear friend....
i use this in formula coulnm in oracle report...
Here given error is............
--no function with name 'LENGTH' exists in this scope.
but if i run the script in sqlplus/TOAD then it gives my required O/P
-------------------------query-------------------------
Select sum(a.Weight) into rolling_op_qty
from PD_PROCESS_OUTPUT_DTL a, Pd_PROCESS_INPUT_DTL b,
PD_PROCESS_HDR c, HM_SHIFT_MST d
where a.Delete_Mark=0 and b.Delete_Mark=0 and c.Delete_Mark=0
and a.Process_Id=b. Process_Id and a.Input_Coil_No=b.Input_Coil_No
and a.Process_Id=c.Process_Id and c.Shift_Code=d.Shift_Code
and Substr(a.Source_Coil,1,10) in
(Select Substr(Source_Coil,1,10) from PD_PROCESS_OUTPUT_DTL
where Delete_Mark=0 and Input_Coil_No=:LOT_NO)
and b.Process_Type in ('Trimming','Rewinding')
and a.process_type not in ('CR Withdrawn','HR Withdrawn','Needs Reprocessing','Withdrawn')
and b.SOURCE_COIL in (select source_coil from pd_process_output_dtl
where next_process in ('Trimming','Rewinding')
and process_type not in ('CR Withdrawn','HR Withdrawn','Needs Reprocessing','Withdrawn')
and LENGTH(Source_Coil)<=30)
order by b.input_coil_no, a.output_coil_no;
|
|
|
|
|
|
| Re: How to get length of column data in oracle form [message #284187 is a reply to message #284131] |
Thu, 29 November 2007 02:16 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Ziauldba, read the OraFAQ Forum Guide and finally learn how to format your post. Statement you've posted is unreadable and unacceptable; do you think someone will spend half an hour just to SEE what you've written?
If you expect the answer, help us to help you.
By the way, don't put Reports-related questions in the Forms forum.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
