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
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
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]
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
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]
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
Is there a open source "Discussion Forum Software" ?.
Thanks in advance.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
7 matches
Mail list logo