joe joe - 1 month ago 6
SQL Question

using declare variables in ORACLE

Hope all doing well. I am having a syntax issue with the declaration in Oracle. I am using these variables on MS SQL server and they work just fine; however, how do I declare these in Oracle?

Use in MS SQL server:

DECLARE @FROM_DT DATETIME
DECLARE @END_DT DATETIME
DECLARE @LOCATION VARCHAR(100)

SET @FROM_DT = '04/01/2011'
SET @END_DT = '05/09/2011'
SET @LOCATION ='VA'


Thanks much!

Answer

You cannot declare variables outside of a PL/SQL block.

The format of variable declarations inside a PL/SQL block is described very detailed in the manual (including examples):

http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/fundamentals.htm#CIHGGIAH