title: how to run this piece of sql code in oracle?
body: <p>I have this code in sql, it runs perfectly on sql server 2005. But when i run this code in isql plus, it gives error, what changes should I make to run it.</p>
  
  <p>code is---</p>
  
  <pre><code>DECLARE @stu_Name VARCHAR(50), @stu_Address VARCHAR(50)
  SELECT @stu_Name = g.stu_Name,@stu_Address= g.stu_address 
  FROM student as g
  WHERE unique_no = 's121' 
  INSERT INTO 
     dbo.student(stu_no, stu_name, dateofbirth,stu_unique_no, stu_name,stu_address)
  VALUES
       (13, 'John', '1990-12-12','s121', @stu_Name, @stu_Address);
  </code></pre>