Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006
    Posts
    1

    Unanswered: EQUALENT TO ORACLE Query

    Dear All,

    I want The Oracle Qry for the following sql Query

    If Not Exists ( Select * from Tbl Where col = @Col)
    and exists ( Select * from tblb b inner join tbl a on b.Col = a.col)


    can any one able to help me

    REGARDS
    KRISHNAKUMAR
    Last edited by csk; 11-28-06 at 03:37.

  2. #2
    Join Date
    Mar 2004
    Location
    Warsaw / Poland
    Posts
    73
    Code:
    var l_col VARCHAR2(30)
    exec :l_col := 'aaa';
    set serveroutput on
    begin
      for x in (
        Select * 
          from tblb b 
            inner join tbl a on b.Col = a.col 
          where not exists (Select * from Tbl Where col = :l_col) 
             and rownum = 1
      ) loop
        dbms_output.put_line('do something here');
      end loop;
    end;
    /

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •