No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Re:
[B]Can someone let me know how the date syntax work. example working with "greatest" 01-oct-02 and 20-may-2003, it accept 20-may-2003 to be the greatest instead of 01-oct-02 which the oldest (greatest) can someone explain this to me. please let me know the logic behind. I have alot of problems with … |
|
Re:
hi how to convert timestamps to date in oracle, and please give me example sql statements help me thanks bala |
|
[code=sql]SELECT NetAmout FROM MONTHLYBILLS WHERE REGNO = '047080809' AND TRUNC(BILLDATE) BETWEEN '01-AUG-2008' AND '30-AUG-2008' [/code] In above Query written 4 rows in which 3 rows showing netamount 0 and last 4 row showing netamout 4200. [code=sql]SELECT DECODE( SIGN(SUM(NETAMOUNT)),0,0) FROM ALMONTHLYBILLS WHERE NETAMOUNT NOT IN (SELECT DECODE( SIGN(SUM(NETAMOUNT)),1,0) FROM MONTHLYBILLS ))[/code] … |
|
I am trying Ms flex Grid attached with combo box. Can anyone give me source or soloution. |
|
Re:
Hi I have used three combo box in VB 6 form one for selecting date one for month and one for year. If the selection is say 12/07/2007 then I need it to be converted as 12/07/2007 under one field i.e date field of access database. So how can I … |
|
I want to begin to create dll in visual basic 6.0. Can anybody give brief idea or examples. |
|
I am using oracle query in that four fields are number. I am subtracting that field such as (field1 - field2 -field3 - field4) as DNF Actually I am creating query in view. While creating this view the last field DNF is created as varchar2(40) automatically. I am using this … |
|
i have the following query SELECT C.FIELD6 ,C.FIELD2,C.TRANSACTIONNO FROM ipfroutine_deduction a,Servicemaster B,INPATIENTBILLALLDETAILS C, Departments D,INPATIENTBILLS E WHERE a.ipftestcd=b.code AND C.BILLNO=E.BILLNO and trim(a.ipftestname)=trim(b.childname) AND TRIM(B.childname)=TRIM(C.FIELD2) AND TRIM(A.IPFDEPTCD)=TRIM(C.DEPTCD) AND TRIM(C.DEPTDESCR)=TRIM(D.NAME) AND E.FROMDATE BETWEEN TRUNC(A.IPFFROMDATE) AND NVL(TRUNC(A.IPFTODATE),E.FROMDATE) AND C.BILLNO = 'D00024585' It's result as NO FIELD6 FIELD2 TRANSACTINO 1 220 CHG (HB TC … |