Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Fastest way to insert data from SQL Server 64 Bit to Oracle

  Hello @ all, could you tell me which is the fastest way to write data from SQL Server 64 Bit to Ora…

  MDave

  3 replies

  15 years, 7 months ago

  By: MDave

• Invalid Data for type "numeric"

  Hi, I'm curious if this issue ever got resolved? I saw many posts on the internet about the exact s…

  Paul Bukowski

  4 replies

  15 years, 8 months ago

  By: sreddyv26

• Sql server to oracle

  Hi all, We have an app server connecting to sqlserverdatabase and oracle database. The applicatio…

  newbieuser

  13 replies

  15 years, 8 months ago

  By: newbieuser

• Query Oracle data from Sql Server using LinkServer

  Hi all I'm have nightmare quering oracle tables from sql server using linkserver. Here is what my q…

  Bhavesh-1094084

  1 replies

  15 years, 8 months ago

  By: PaulB-TheOneAndOnly

• Oracle Linked Server Error (Oracle client and networking components were not found)

  Hi Everyone, We have a linked server setup to connect to one of our Oracle 8i databases. The linked…

  speja01

  1 replies

  15 years, 8 months ago

  By: PaulB-TheOneAndOnly

• Pulling data from Oracle into SPSS through an ODBC

  I am trying to pull some data from two Oracle databases into SPSS. I do this all the time. Simple, …

  sherrina.gibson

  3 replies

  15 years, 9 months ago

  By: PaulB-TheOneAndOnly

• equivalent for rownum

  Hi friends, I do 'select rownum from table' in oracle to select rows ordered by rownum. What is th…

  newbieuser

  32 replies

  15 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Error while scheduling SSIS package in SQL server 2005

  Hi, I had created an SSIS packege which executes successfully when manually executed. I schedule th…

  DBAsql-1046554

  2 replies

  15 years, 9 months ago

  By: DBAsql-1046554

• Importing of data from Oracle to sqlserver taking 6hrs

  There is a job(scheduled daily) which brings in around 500,000 records from Oracle server to Sql se…

  rekha_sara

  12 replies

  15 years, 9 months ago

  By: SQLDCH

• SQL 2005 64 bit - oracle 10g X64 - does not work..please help

  i have read so many forums but could not find an answer..so please only person with right solution …

  curious_sqldba

  11 replies

  15 years, 9 months ago

  By: curious_sqldba

• Can SQL Server decrypt a table that was encrypted by Oracle?

  I've got two databases - one oracle (Oracle 10g), the other sql server (SQL Server 2000 (I know... …

  thomas.gervais

  4 replies

  15 years, 9 months ago

  By: thomas.gervais

• Trouble with decode

  Hi, Can somebody help me how to convert this to sql server query using CASE stmt? ,DECODE(c1.name, …

  rekha_sara

  4 replies

  15 years, 9 months ago

  By: shweta02sharma

• Updating Oracle through linked server

  Hi All, I am trying to update specific rows in our Oracle database which will be selected by a list…

  david.murden

  3 replies

  15 years, 9 months ago

  By: chandan_jha18

• Oracle PL SQL UPDATE optimization

  Hello, I am struggling with this SQL code. I use Oracle SQL Developer and it compiles fine without …

  metalray

  3 replies

  15 years, 9 months ago

  By: PaulB-TheOneAndOnly

• Trying to create a linked server from SQL 2005 EE to Oracle 9i EE using GUI

  Hello, I'm trying to create a linked server from SQL 2005 EE to Oracle 9i EE using SQL GUI. But not…

  pankaj.baluni

  2 replies

  15 years, 10 months ago

  By: Lowell