Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-04-29 : 03:23:09
|
| hi, can anyone help me to give out this sql server procedure into oracleIF EXISTS (SELECT name FROM sysobjects WHERE name = 'GetMedian' AND type = 'P')DROP PROCEDURE GetMedianGOCreate Procedure GetMedian (@SQLStmt Varchar(8000)) AS Declare @String Varchar(8000), @Value int, @Row1 int, @Row2 int, @Value1 Decimal(20,3), @Value2 Decimal(20,3) Begin SET @String = 'Declare CurMedian CURSOR SCROLL FOR ' + @SQLStmt EXEC (@String) OPEN CurMedian SET @Value = @@Cursor_Rows IF (@@Cursor_Rows%2) = 1 Begin SET @Row1 = (@Value/2)+1 SET @Row2 = 0 Fetch Absolute @Row1 From CurMedian INTO @Value1 SET @Value = @Value1 End Else Begin SET @Row1 = (@Value/2) SET @Row2 = (@Value/2)+1 Fetch Absolute @Row1 From CurMedian INTO @Value1 Fetch First From CurMedian Into @Value2 SET @Value2 = 0 Fetch Absolute @Row2 From CurMedian INTO @Value2 SET @Value = (@Value1 + @Value2)/2 End Close CurMedian Deallocate CurMedian Select @Value End GO |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-04-29 : 04:18:02
|
| this is sql related forums try to post in www.dbforums.com |
 |
|
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
Posted - 2009-04-29 : 04:23:45
|
| actually i am very much new to ms sql could anyone help me to give out in oracle |
|
|
|
|
|
|
sql server procedure into oracle