Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Oracle 11g Linked Server OLE DB Data Type Error

  Hello.... Okay so my company has just upgraded its accounting package to Oracle 11g...and we have c…

  chris.thornburg

  6 replies

  14 years, 5 months ago

  By: chris.thornburg

• Compress openquery results?

  Hey guys, I will often use openqueries and SSIS to pull data from one of our Oracle servers in my S…

  coder_t2

  3 replies

  14 years, 6 months ago

  By: coder_t2

• Working with Oracle

  SELECT SalesProductKeyID,ActualUnitPrice,BillDateKeyID,ProductKeyID ,Qty,Profit,DD.dDate, (SELECT…

  chakrapanishroff

  5 replies

  14 years, 7 months ago

  By: PaulB-TheOneAndOnly

• How to create user in Oracle 9i

  Hi I am new in Oracle,but i work mainly on sql server 2000 & 2005.I just install the oracle 9…

  John-1015474

  16 replies

  14 years, 7 months ago

  By: PaulB-TheOneAndOnly

• project

  hi, I have one table student and three fields mtt1,mtt2 and sum.I want to update sum field whenever…

  kanika.bhagat

  5 replies

  14 years, 7 months ago

  By: PaulB-TheOneAndOnly

• SQL Server vs Oracle Stored Proc OUTPUT parameters

  I need to get and integration solution to run on both SQL Server 2005 and Oracle instances of the s…

  dwmllr

  3 replies

  14 years, 7 months ago

  By: PaulB-TheOneAndOnly

• 32 or 64 BIT on a SQL2K5 64-BIT Server?

  I have a SQL2005 32-bit Server. I installed the Oracle 11gR2 32-bit Client. I then created a LINKED…

  rew-370421

  2 replies

  14 years, 7 months ago

  By: rew-370421

• Difference between Oracle & SQL Server at high level.

  Hi All What are the difference between Oracle(Say Oracle 10g) and SQL Server (Say SQL Server 200…

  saurabh.deshpande

  9 replies

  14 years, 8 months ago

  By: PaulB-TheOneAndOnly

• openquery, openrowset or neither?

  Within my SQL2005 Instance (32BIT), I successfully created and queried to an Oracle database. From …

  rew-370421

  2 replies

  14 years, 8 months ago

  By: rew-370421

• Oracle Number Datatype

  I have a SSIS package I'm developing against an Oracle datasource. While trying to incrementally l…

  cmbrooks08

  4 replies

  14 years, 8 months ago

  By: bambang

• Attunity driver Usage

  There was a nice blog post over on http://blogs.msdn.com/sqlperf/archive/2009/08/14/using-ssis-to-g…

  S. Kusen

  3 replies

  14 years, 9 months ago

  By: willtwc

• Importing an oracle db

  We have a single oracle database on our servers, and we want to bring it into sql server so we no l…

  Mark Harley

  1 replies

  14 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Package fails when adding field from Oracle

  We have an integration services package which collects data from an Oracle 7 database. At the mome…

  S Hodkinson

  8 replies

  14 years, 9 months ago

  By: S Hodkinson

• Openquery hanging, is it Oracle or SQL Server's fault?

  I am having a problem where an openquery isn't populating a table. It just hangs. Ok let me give yo…

  coder_t2

  8 replies

  14 years, 9 months ago

  By: PaulB-TheOneAndOnly

• How to connect to Oracle 9i via Instant Client from Oracle

  I have a SQL 2008 64 bit and I need to connect to Oracle 9i to read data via SSIS 2008. I have alre…

  bechihai

  3 replies

  14 years, 9 months ago

  By: PaulB-TheOneAndOnly