it would be something like this
UPDATE A
SET column = value
WHERE store of A in (SELECT store FROM B);...
soumya1011
Last Activity: Jun 25 '07, 09:44 AM
Joined: May 9 '07
Location:
-
SELECT name,salary
FROM (SELECT name,
salary,
rank() over (order by salary desc) rank
FROM employee)
WHERE rank in (2,3);Leave a comment:
-
The equivalent for DECLARE @somevariable int would be
somevariable number;
to initialize it
somevariable:=1 ;
and you can select its value as
SELECT somevariable FROM dual;
If you want to select some value which is in a table then you can use this
SELECT column_name
INTO somevariable
FROM table_name;Leave a comment:
No activity results to display
Leave a comment: