Home » SQL & PL/SQL » SQL & PL/SQL » Migrating testscript from MS SQLServer to Oracle
Migrating testscript from MS SQLServer to Oracle [message #312986] Thu, 10 April 2008 04:53 Go to next message
baronq
Messages: 2
Registered: April 2008
Junior Member
Hi,

I'm working on a project where a MS SQLServer application is being migrated to Oracle. I've developed a testscript for MS SQLServer and now it's my job to make one for Oracle. However, I have no idea how to declare variables in Oracle.

This is a part of my MS SQLServer script.

DECLARE @AantalUur decimal (38, 32)

DECLARE @AantalUur decimal (38, 32)

SELECT
@AantalUur = ISNULL(SUM(CONVERT(decimal(38, 32), Werk.AantalUur)), 0)
FROM
dms_fct_FCT_BAS_kijkt_vooruit Werk
INNER JOIN dms_cnf_DIM_SoortOpdracht SoortOpdracht ON (1=1)
AND (Werk.SK_DIM_Soortopdracht = SoortOpdracht.SK)
INNER JOIN dms_cnf_DIM_Dienst Dienst ON (1=1)
AND (Werk.SK_DIM_Dienst = Dienst.SK)
INNER JOIN dms_cnf_DIM_Organisatie Organisatie ON (1=1)
AND (Werk.SK_DIM_Organisatie = Organisatie.SK)
INNER JOIN dms_cnf_DIM_BelemmerdeActiviteit BelemmerdeActiviteit ON (1=1)
AND (Werk.SK_DIM_BelemmerdeActiviteit = BelemmerdeActiviteit.SK)
INNER JOIN dms_cnf_DIM_Doorrekenbasis Doorrekenbasis ON (1=1)
AND (Werk.SK_DIM_Doorrekenbasis = Doorrekenbasis.SK)
INNER JOIN dms_cnf_DIM_KalenderDag Kalender ON (1=1)
AND (Werk.SK_DIM_KalenderDag = Kalender.SK)
INNER JOIN dms_cnf_DIM_AchterstalligWerk AchterstalligWerk ON (1=1)
AND (Werk.SK_DIM_AchterstalligWerk = AchterstalligWerk.SK)
INNER JOIN dms_cnf_DIM_Bron Bron ON (1=1)
AND (Werk.SK_DIM_Bron = Bron.SK)

Anybody can help me out?

Thanx in advance,

Rik
Re: Migrating testscript from MS SQLServer to Oracle [message #312990 is a reply to message #312986] Thu, 10 April 2008 05:17 Go to previous messageGo to next message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Did you check the documentation (PL/SQL guide)?

10g documentation:
http://www.oracle.com/technology/documentation/database10gr2.html

PL/SQL:
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14261/toc.htm
Re: Migrating testscript from MS SQLServer to Oracle [message #313038 is a reply to message #312990] Thu, 10 April 2008 08:11 Go to previous message
baronq
Messages: 2
Registered: April 2008
Junior Member
Thanx! I just didn't seem te get anywhere, that's why I posted. Thanks to the second link you provided, I've been able to solve my problem.

Well, sort of.......

The DBA hasn't created the table mentioned in the FROM clause yet....

Rik
Previous Topic: FROM TABLE, SELECT
Next Topic: Exception within the loop
Goto Forum:
  


Current Time: Sun Dec 04 20:34:44 CST 2016

Total time taken to generate the page: 0.07689 seconds