RE: [OT off topic] Oracle Database Performace Issue

2006-02-10 Thread Jonnalagadda, Sumithra
statement? Larry On 2/10/06, Jonnalagadda, Sumithra <[EMAIL PROTECTED]> wrote: > Here is the query > > > > SELECT PTI.PARTY_ID AS "CUSTID", > PTI.CMA_CUSTOMER_NUMBER AS "CUSTNUM", > PTI.SOURCE_ID AS "CUSTSOURCE", > PTI.PARTY_CLASS_CD

RE: [OT off topic] Oracle Database Performace Issue

2006-02-10 Thread Jonnalagadda, Sumithra
Here is the query SELECT PTI.PARTY_ID AS "CUSTID", PTI.CMA_CUSTOMER_NUMBER AS "CUSTNUM", PTI.SOURCE_ID AS "CUSTSOURCE", PTI.PARTY_CLASS_CD AS "CLASS", (SELECT CMAPSV.STATUS_VALUE FROM type3 CMAPS, type4 CMAPSV WHERE PTI.PARTY_TYPE_INSTANCE_ID = CMAPS.PARTY_TYPE_INSTANCE_ID AND CMAPS.PARTY_STATUS

[OT]Loading data into oracle database table from a txt file.

2006-02-06 Thread Jonnalagadda, Sumithra
I have data in a text file with a delimiter. How will I import this data into a table in orcale database? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

For sql experts

2006-02-03 Thread Jonnalagadda, Sumithra
SELECT DEPTNUM.REF_VALUE, CAMNUM.REF_VALUE, (SELECT PN1.NOTE_TEXT FROM PARTY_NOTE PN 1WHERE PN.1PARTY_ID = DEPTNUM.PARTY_ID and max(pn1.last_update_dt)) NOTE FROM PARTY_REFERENCE DEPTNUM, PARTY_REFERENCE CAMNUM, PARTY_ASSOC REL WHERE DEPTNUM.PARTY_ID = REL.TO_PARTY_ID AND REL.FROM_PARTY_ID = CAMN

Wireless Development mailing List

2006-02-01 Thread Jonnalagadda, Sumithra
I am sorry for this off topic post. What are the open source tools for wireless software development?. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

RE: Discussion forum software -- open source

2005-12-27 Thread Jonnalagadda, Sumithra
Thanks Daniel and Vikram for your responses. I have never used a open source in a commercial application till now. If I plan to use say phpBB in a commercial application is there anything I need to take of legally?. Thanks -Original Message- From: Daniel Blumenthal [mailto:[EMAIL PROT

Discussion forum software -- open source

2005-12-26 Thread Jonnalagadda, Sumithra
Is there a open source "Discussion Forum Software" ?. Thanks in advance. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]