Re: Need Similar Oracle Query ?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Luqman (pearlsoft_at_cyber.net.pk)
Date: 02/05/05

  • Next message: Rick Stanford: "Check to see if a connection object exists" 
    Date: Sat, 5 Feb 2005 18:19:09 +0500

    I am using Oracle 9i, Version 9.2.0

    Best Regards,

    Luqman

    "Al Reid" <areidjr@reidDASHhome.com> wrote in message
    news:eJ$pIurCFHA.2072@TK2MSFTNGP10.phx.gbl...
    > "Luqman" <pearlsoft@cyber.net.pk> wrote in message
    > news:OkoulJrCFHA.2568@TK2MSFTNGP10.phx.gbl...
    >> I have created this query in Sql Server 2000 and I need to run similar
    >> query
    >> in Oracle.
    >>
    >> update cont_item
    >> set psqft=sqsm
    >> from mcontract b
    >> inner join cont_item c on b.cn=c.cn and b.rev=c.rev
    >> and b.uqty like '%F%'
    >>
    >> MContract is Master Table
    >> Cont_Item is Detail Table
    >> Both linked with two keys : CN,REV
    >>
    >> The Cont_Item has Two Quantity Fields, psqft and sqsm
    >>
    >> I need all psqft fields should be equal to sqsm field
    >> where their Parent Record in Contract Table Field UQTY like '%F%'
    >>
    >> Best Regards,
    >>
    >> Luqman
    >>
    >
    > What version or oracle are you running?
    >
    > --
    > Al Reid
    >
    >

  • Next message: Rick Stanford: "Check to see if a connection object exists"

    Relevant Pages

    • Re: Query to use like values from other table
      ... or similar to above query. ... Best Regards, ... Luqman ... >> The ways I know is either use union query ...
      (microsoft.public.sqlserver.programming)
    • Re: CLOB SUPPORTED in Delphi 5/7 ADO ?
      ... Microsoft's equivalent which doesn't seem to like CLOBs or BLOBs. ... Oracle CLOBs can be problematic using Delphi and ADO. ... Have writen the query ... >>> Best regards. ...
      (borland.public.delphi.database.ado)
    • Re: Hunting got CPU Cost
      ... CPU and its cost for the query for which it is being utilized in ... Regards ... Puget Sound Oracle Users Group ...
      (comp.databases.oracle.server)
    • Query to export data from Access 2003 to Oracle ?
      ... How can I export data from Access 2003 to Oracle using Query? ... Best Regards, ... Luqman ...
      (microsoft.public.access.queries)
    • Re: Views - performance
      ... when u use stored object views oracle has to read the data dictionary ... this includes lots of steps for execution ... semantics of the query and fires it ... you'll possibly have any idea is to use explain plan to provide a base ...
      (comp.databases.oracle.server)