Tagged Questions
2
votes
2answers
982 views
How do I declare and use variables in Oracle?
My main skills are with SQL Server, but I have been asked to do some tuning of an Oracle query. I have written the following SQL:
declare @startDate int
select @startDate = 20110501
And I get this ...
4
votes
3answers
218 views
How can I fix the Oracle syntax of this update by the result of a select in Oracle 10g?
I have a problem with an update statement, that I developed under 11g, when running under 10g.
I reduced the problem to:
Create table test (
col1 number(10)
);
insert into test values (1);
...
