8 Replies Latest reply: Feb 15, 2013 4:00 PM by 991386 RSS

    SQL Developer equivalent of SQL Server Management Studio

    991386
      Hello,

      What is equivalent in Oracle SQL Developer for following MS SQL Server SQL written in SQL Server Management Studio?

      DECLARE @VALUE_ID VARCHAR(15);
      SET @VALUE_ID='000000000079246';
      SELECT * FROM TABLE WHERE FIELD=@VALUE_ID;


      I tried various combination but SELECT * FROM TABLE WHERE FIELD=@VALUE_ID doesn't seem to be working. It asks for INTO clause.

      Thanks
      Pravin