CODEWITHSUNDEEP
sqlplsql
joe
joe

Reputation: 1473

Using declare variables in Oracle

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'

Upvotes: 3

Views: 3563

Answers (2)

Fırat Küçük
Fırat Küçük

Reputation: 6003

You may pass variables to other sql files. It's not exactly what you want but it helps me to solve some problems without using blocks.

For Instance my config.sql file:

@drop.sql 'MY_USER'

my drop.sql file:

DROP USER "&1" CASCADE;

Upvotes: 0

user330315
user330315

Reputation:

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

Upvotes: 4

Related Questions