Recent content by Iniyavan B R

  1. I

    Could not locate OCI dll - Please help

    Hi all, Please help me to solve the "Could not locate OCI dll" error. I tried entering dll location in OCI Library field. But nothing works. Thanks in advance! (I am unable to attache the screen shot of the error. Or else, I would have attached it.)
  2. I

    Generating a Package to Insert Data into a Table

    Hi all, Is there an option in PL/SQL Develpoer 7.1, from a table to generate a packaged procedure which is used for inserting data in to the table? For example, if we right click (or any other option) a table, there should be an option which will create a package. The package contains prcedure...
  3. I

    Convert Oracle join to ANSI join

    No, Pedersen. My question is, that is there any option in PL/SQL Developer 7.1 to convert the queries written using the old-style joins (using "(+)") to new ANSI joins (using "LEFT OUTER JOIN"). Thanks in advance!
  4. I

    Convert Oracle join to ANSI join

    Here is an example for Oracle join: SELECT a.acct_num, a.grp_num, a.div_num, a.sub_pers_num, a.pat_pers_num, a.pat_dob, a.rel_code, b.pat_pmt, b.deductible_amt, b.net_pmt FROM source.master_claim a, source.master_line b...
  5. I

    Convert Oracle join to ANSI join

    Hi, I am using PL/SQL Developer 7.1.1. Could you please help me to convert the SQL queries written using Oracle join to ANSI join?
See more
Back
Top