Re: Problemi con Vb/Oracle

From: <rtproffitt_at_my-deja.com>
Date: Fri, 08 Sep 2000 16:20:50 GMT
Message-ID: <8pb3ka$e5$1@nnrp1.deja.com>

Buon Giorno, Alessandro....

(english translation follows afterwards...) Mi scuzo per non parlo l'italiano bene.... (Studio 2 semesteri multi ani fa)...

1. Non ho experienza con "CLOB"....
2. Nell seguente instruzione: INSERT INTO TABLE (ID, Code, Description) VALUES (5,'abc','') Nell Oracle SQL, non si mette due "apostrophe" ('), invece, quest'è vuoldire "One literal apostrope" '' = literal ' character Correctemente, si puoi usare "NULL" INSERT INTO TABLE (ID, Code, Description) VALUES (5,'abc',NULL)

   Anche, Oracle non ha "Empty String" come lingua C: ""

        ...Solamente NULL e '....text....'

        "non tutti i record potrebbero essere "pescati"    Correct, NULL non è lo stesso come avere "data"    Dunque, nella phrase

        WHERE Description LIKE '%'"
   Oracle non trova (?) tutti recordi a dove Description è NULL    e....

         sql = "SELECT * FROM TABLE WHERE Description LIKE '%' OR Description IS

> NULL"

   è il metodo correcto.
   .... Forse un altro instruzione anche correct:    sql = "SELECT * FROM TABLE WHERE nvl(Description,'x') LIKE '%'

RT>select * from bob where dept like '%'; DEPT DEPTID EMP EMPID
---------- ---------- ---------- ----------

DEPTA      A          Julie      766
DEPTA      A          Johann     655

RT>select * from bob where nvl(dept,'x') like '%'
DEPT       DEPTID     EMP        EMPID
---------- ---------- ---------- ----------
           A          Bill       877
DEPTA      A          Julie      766
DEPTA      A          Johann     655

3) Non so "DistinctRow".

    ...è Forse lo stesso come:

            Select Distinct a,b,c,d,e,f From TableX     dove a,b,c,d,e,f sono tutti campi nel record?

4) Non ho experienza con "CLOB"....

5) tu: "questo metodo non funziona :....

        sql = "UPDATE Tabella1 INNER JOIN Tabella2 ON Tabella1.Id =


        > Tabella2.IdTabella1

        Set Tabella1.Campo = Tabella1.Campo - 1 WHERE

Tabella2.AltroId=" & Id

   Qui è l'instruzione lo stesso nel "Oracle":

        Update T1
          Set T1.Campo = T1.Campo - 1
        Where T1.ID IN
          (Select T2.IDT1 From T2
           Where T2.AltroID = &IDVal)

Good Luck!
Robert Proffitt
Beckman Coulter
Brea, California, USA
RTProffitt_at_beckman.com

ENGLISH:
1) I don't have any experience with CLOBs 2) In the following instruction:

         INSERT INTO TABLE (ID, Code, Description) VALUES (5,'abc','')    In Oracle you can't use two apostrophes for NULL, instead, these    have the meaning of one literal apostrophe character    The correct syntax is to use the NULL word

         INSERT INTO TABLE (ID, Code, Description) VALUES (5,'abc',NULL)    Also, Oracle does not have the concept of an Empty String ("") like    other languages...only NULL and string text

        "non tutti i record potrebbero essere "pescati"    Correct, NULL is not the same as having data.    Therefore, in

        WHERE Description LIKE '%'"
   Oracle does not find any of the records where desription is null    and...

         sql = "SELECT * FROM TABLE WHERE Description LIKE '%' OR Description IS

> NULL"

   is the correct method.
   You may also try this alternate method:    sql = "SELECT * FROM TABLE WHERE nvl(Description,'x') LIKE '%'

3) I don't know what DistinctRow is, but perhaps it is the same as...

            Select Distinct a,b,c,d,e,f From TableX    where a,b,c,d,e,f are all the fields in the record?

4) No experience with CLOBs

5) The update clause in OracleSpeak would be:

        Update T1
          Set T1.Campo = T1.Campo - 1
        Where T1.ID IN
          (Select T2.IDT1 From T2
           Where T2.AltroID = &IDVal)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 08 2000 - 11:20:50 CDT