This discussion is archived
8 Replies Latest reply: Feb 15, 2013 2:00 PM by 991386 RSS

SQL Developer equivalent of SQL Server Management Studio

991386 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points