can you try this out and let me know...........
SELECT LN.STORE_CD, LN.LOC_CD, LN.DEL_DOC_NUM, LN.DEL_DOC_LN#, LN.ITM_CD, LN.QTY*100,
LN.OUT_CD, LN.OUT_ID_CD
FROM LOC LOC, SO_LN LN,STORE S2,SO SO2 ,ITM I2,IST_LN$SO_LN ILSL , INV_XREF IX
where S2.STORE_CD = LN.STORE_CD
and ND NVL(S2.RF_WHSE, 'N') = 'Y'
and SO2.DEL_DOC_NUM = LN.DEL_DOC_NUM
AND SO2.STAT_CD = 'O'
AND SO2.ORD_TP_CD...
bonzi1405
Last Activity: Jun 8 '07, 09:07 AM
Joined: May 3 '07
Location:
-
As per my understanding to your question, below is the script
Try this out.
select count(col1),cou nt(col2),count( col3)
from(
select distinct caseno col1,
( select distinct caseno from 31_Table where after_step <> 99) Col2,
( select distinct caseno from 31_Table where after_step = 99) Col3,
from 31_Table
)...Leave a comment:
-
select replace(transla te('12acdf45534 fdfddy5gfg56789 fgas636382','ab cdefghijklmnopq rstuvwxyz','~') ,'~','') from dual
select replace(transla te('12acdf45534 fdfddy5gfg56789 fgas636382','01 23456789','~'), '~','') from dual...Leave a comment:
-
Below will return n,n+1 higest salary of a table.
select min(salary) sal
from
( select salary from employee order by salary desc)
where rownum<=&n
union
select min(salary) sal
from
( select salary from employee order by salary desc)
where rownum<=&n+1Leave a comment:
-
As per the requirement, below script will print
Low for <2000
High for>2500
but null for 2000 to 2500
select decode(least(&s alary,2000),200 0,decode(greate st(&salary,2500 ),&salary,'High '),'Low') print from dual...Leave a comment:
No activity results to display
Leave a comment: