All Questions
8 questions
1
vote
3
answers
992
views
How to connect to an Oracle db using a stored procedures within a Microsoft SQL server?
I need to verify data between and Oracle db and a Microsoft SQL server db to verify that if there differences between the two and then update the Microsoft SQL server with any changes there may be
- 172
-2
votes
3
answers
1k
views
How to run store procedures simultaneously
I'm doing a job to tuning some store procedures got situation like this:
there is a procedure let's call it sp_summary it will do some prepare work first and then it will exec like 10 procedures in ...
- 552
0
votes
0
answers
181
views
Stored Procedure Passing a Null into Dataset upon Refresh -- SSRS / Oracle 11g
I have a report built in Visual Studio 2012 from a stored procedure created in a DB I have no access to (Oracle 11g). The SP was updated to include 3 new columns that needed to be added to the report, ...
0
votes
2
answers
2k
views
Convert SQL Server stored procedure to Oracle procedure to query from tables
I'm trying to move from SQL Server to an Oracle database. I have to move my stored procedure from SQL Server to Oracle that do a query from multiple table with an INNER JOIN. I am trying to clarify ...
- 377
-1
votes
1
answer
1k
views
To create a stored procedure for counting distinct values for 8 columns
I have a table product in which I have 8 columns and I have to count the distinct values. To achieve this, I need to create a stored procedure.
So, how to create it?
This is the sample I have wrote ...
- 11
1
vote
0
answers
94
views
Pass SQL Server stored procedure to oracle pl/sql stored procedure
I have two procedures in SQL Server I want to pass to Oracle:
ALTER PROCEDURE [dbo].[usp_GetSettingValueByIndividualKey]
@PortalID INT
,@SettingKey NVARCHAR(256)
AS
BEGIN
IF EXISTS (...
- 311
0
votes
1
answer
53
views
Create SQL Server Stored Procedure that will get last_Run_DateTime column from ORACLE table
Is there a way to create stored procedure in sql server that will go to my table in Oracle db and get the last run datetime?
- 2,265
-1
votes
1
answer
91
views
Error with select case statement [closed]
How to convert this T-SQL query into Oracle?
if((select case
when (select top 1 AlertMessage
from ims.dbo.alertlist
where SystemID=@meter
order by ...
