Tag: oracle

Deploy Sql Changes to Customer Databases (altered tables, functions,…)

I am developing an application that uses a database (either PostgreSQL, MySQL, Oracle or MSSQL) on the customers system. Therefore I need to perform database updates with each new version. I am currently in the concept phase and have nothing running in production. All the DDL statements are in script files. The structure looks like […]

How to combine two sql select statement

I have two SQL select statement that says SELECT TOP (150) FoodID, COUNT(*) AS NumberOfFood FROM FoodTable WHERE FoodID IS NOT NULL AND FoodDate >= ‘2015-10-01’ GROUP BY FoodID ORDER BY NumberOfFood DESC I also have another SQL statement SELECT FoodSellerID, Market1, SellerLastName, SellerFirstName, PrimaryAddress1, PrimaryAddress2, PrimaryCity, PrimaryState, PrimaryZip FROM SellerTable, MarketTable WHERE Market1= MarketTable.MarketID […]

How can i use int32 variables Expression builder in SSIS

In the expression builder, my query looks something like this. SELECT * FROM TABLE_A WHERE COLOMN_A_ID IN (SELECT COLOMN_A_ID FROM TABLE_B JOIN EXTRACT_STATUS ON EXTRACT_DTTM > TO_DATE(‘” + (DT_WSTR, 30) @[User::LastTransferDT] + “‘, ‘mm/dd/yyyy hh:mi:ss AM’) AND TABLE_B.Scheduled_DT BETWEEN EXTRACT_STATUS.RANGE_BEGIN_DTTM AND EXTRACT_STATUS.RANGE_END_DTTM AND F_MPOG_EXTRACT.extract_num =”+@[User::RowNumber]+ “)”` I keep getting the same error again and again. […]

MSSQL Data type conversion

I have a pair of databases (one mssql and one oracle), ran by different teams. Some data are now being synchronized regularily by a stored procedure in the mssql table. This stored procedure is calling a very large MERGE [mssqltable].[Mytable] as s USING THEORACLETABLE.BLA as t ON t.[R_ID] = s.[R_ID] WHEN MATCHED THEN UPDATE SET […]

Copying Data from Oracle Server to SQL Server

I’m quite new to coding in general and I’m looking to copy 47 columns with c300,000 rows of data, from an Oracle to an SQL database, on a daily basis. The code will be stored as a Windows Service, running at the same time every day (or more likely night). The data from the Oracle […]

MS SQL: Call function with parameter from linked Oracle server

I’ve got MS SQL Server. There is a linked ORACLE server on it named HOST4KS. At Oracle DB I have two functions – one parameterless and one with parameter. I need to get their result in my tsql query. 1) function without parameter RetVal:=KSOL.routines.Tst; It always returnes int = 123 DECLARE @Resultint select top 1 […]

What is a good way to open large files across a WAN?

I have an application deployed into multiple zones and there are some issues with opening larger documents (20-50MB) across the WAN. Currently the documents are stored in Zone 1 (Americas) and a link stored in the database to the docs. I have heard some things about blobs in oracle and store binary in MS SQL […]

Transform update statement with joins from SQL Server into Oracle

This update statement works perfectly on SQL Server, but on Oracle doesn’t. UPDATE wfu set klient_id_crma= K.KLIENT_PROD_ID , umowa_id_crma= u.umowa_id from wh_ods.umowy u join WNIOSKI_umowy wfu on u.NUMER_REFERENCYJNY = wfu.numer JOIN WH_ODS.KLIENCI K ON U.KLIENT_ID= K.KLIENT_ID What is the simplest way to make update with few joins on Oracle? that method returns error: UPDATE (SELECT […]

How can I generically detect if a database is 'empty' from Java

Can anyone suggest a good way of detecting if a database is empty from Java (needs to support at least Microsoft SQL Server, Derby and Oracle)? By empty I mean in the state it would be if the database were freshly created with a new create database statement, though the check need not be 100% […]

The entity framework and database agnostic programming, possibilities?

We want to use the Entity Framework (.NET 4.0) to build applications that can deal with Sql Server, MySQL and Oracle. And maybe Sqlite too. It should be easy to switch the db vendor by some setting in a config file. Is this possible? I prefer real life examples! What kind of providers did you […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.