Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Number of Characters

  Hi! How can I find how many characters are in one field, the value in the field is without spaces! …

  Dugi

  4 replies

  15 years, 12 months ago

  By: PaulB-TheOneAndOnly

• LONG data truncated when migrating from Oracle to SQL Server

  I am trying to import data from Oracle to SQL Server. In the Oracle table I'm pulling from, it has…

  Dizzy Desi

  6 replies

  16 years ago

  By: Dizzy Desi

• Enable Oracle Role with OLE-DB?

  I need to enable a role with OLE-DB in C++. I guess it would be a general SQL statement so I presu…

  Randy-914965

  7 replies

  16 years ago

  By: aj-753163

• Oracle create table syntax

  Can anyone explain to an Oracle novice why both of these create table statements run fine individua…

  Gail Shaw

  15 replies

  16 years ago

  By: aj-753163

• Oracle Query help!

  In aircraft industry, the flight from one place to its destination called leg, but some requests ha…

  Frank He

  5 replies

  16 years ago

  By: aj-753163

• Quicken up a SQL 2005 to Oracle Query

  I have been adding to this query that runs over a linked connection from a sql 2005 server to a ora…

  Stubby Bunny

  6 replies

  16 years ago

  By: PaulB-TheOneAndOnly

• Oracle Linked server missing records

  Hi, This is a doozy.... OK, so I have a new Oracle 10g server and a new SQL 2005 (32bit) server on …

  Richard Gardner-291039

  3 replies

  16 years ago

  By: Richard Gardner-291039

• SQL 2005 Job Connecting to Oracle Linked Server Hangs Infinitely

  SQL Query: SELECT {Columns} INTO (SQL Server Table} FROM {Oracle Linked Server Table} This Query ru…

  Sakthivel Chidambaram

  2 replies

  16 years ago

  By: Sakthivel Chidambaram

• Windows Server Enterprise 64 bit provider needed

  I am converting a few SQL Server 2005 SSIS packages from Windows Server 2003 R2 Standard SP2 to 64 …

  Alan Spillert

  5 replies

  16 years ago

  By: Gift Peddie

• Linked Server Oracle OLEDB Driver Missing

  I have virtually zero knowledge of Oracle. I wanted to setup a linked server from a Windows 2003 S…

  dmc-608719

  4 replies

  16 years ago

  By: MOFONOLE

• Error Using BEGIN TRANSACTION and COMMIT from SQL 2000 with Oracle linked server

  Hi.. this is the scenario... Configured Linked Server from SQL2000 SP4 to Oracle 10G server... Link…

  Freeman_74

  2 replies

  16 years ago

  By: Freeman_74

• Oracle migration

  Hi expertz How to migrate from DB2 mainframe environment to an open UNIX environment based on Oracl…

  Eswin

  1 replies

  16 years ago

  By: PaulB-TheOneAndOnly

• How to set DBMS_APPLICATION_INFO.SET_CLIENT_INFO in linked ORACLE server from SQL 2000

  I could manage to create the linked server from SQL 2000 to Oracle 9i like this: EXEC sp_addlinkeds…

  Freeman_74

  1 replies

  16 years ago

  By: PaulB-TheOneAndOnly

• Convert Oracle ctl files to BCP fmt files

  I am looking into migrating my data warehouse from Oracle to SQL Server. The warehouse was initiall…

  ms-822024

  8 replies

  16 years, 1 month ago

  By: PaulB-TheOneAndOnly

• Temp tables and table variable analogies in Oracle

  I would like to know what replaces Temporary tables in T SQL Stored Procedures.If I have to write t…

  Nilesh-788004

  4 replies

  16 years, 1 month ago

  By: PaulB-TheOneAndOnly