Post reply

silly oracle query error( a headache)

  • September 16, 2004 at 5:35 am

    #523296

    select syspolicy_no,ref_no from policy p join COINSURANCE_DETAILS c on l.syspolicy_no=c.ref_no

    i dont know whats wrong in this query, but even such a simple query doesn't work in oracle 8i.

    such type of query always work in sql server

    actually iam sqlserver developer, just working on oracle, becoz of some requirement, and things which were working on ms-sql, simply didn't work on oracle.

    YOU PPL KNOW ORACLE

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • September 16, 2004 at 7:38 am

    #523326

    I hesitate to reply, but this should be a short, simple answer:  remember that Oracle8i does not support the ANSI join syntax (the syntax using the word "join").  On 8i you'll have to write that join the "old" way, as in: 

    select syspolicy_no,ref_no 
from policy p, COINSURANCE_DETAILS c 
where l.syspolicy_no=c.ref_no

    But I do agree with the others that you should post these questions on an Oracle newsgroup or site.  Someone mentioned that there also may be an Oracle forum at this site, although I can't find it.

    Chris

  • September 16, 2004 at 7:54 am

    #523330

    my final question

    how do i write this query to show results with the left join in oracle 8i

    select syspolicy_no,ref_no from policy p join COINSURANCE_DETAILS c on l.syspolicy_no=c.ref_no

    any idea?

     

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • September 16, 2004 at 7:56 am

    #523332

    I thought there was an Oracle forum (maybe there was one and now it's gone).

    Sukhoi,

    Since this site is SQL Server specific and not Oracle, I would like to suggest that you check out http://www.tek-tips.com which does have Oracle forums (along with SQL Server forums).

    -SQLBill

  • September 16, 2004 at 7:56 am

    #523331

    my final question

    how do i write this query to show results with the left join in oracle 8i

    select syspolicy_no,ref_no from policy p join COINSURANCE_DETAILS c on p.syspolicy_no=c.ref_no

    any idea?

    hey dont include +signs,

    select syspolicy_no,ref_no from policy p,coinsurance_details c where

    p.syspolicy_no=c.ref_no(+)

    i dont want this query, becoz parser gets confused thats what u said.

     

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply