Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Oracle reserved words problem

  Recently my company moved from SQL Server 2005 to Oracle. In SQL Server certain field names like n…

  millerfw

  14 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• Linked Server to Ctree

  I am trying to add a Ctree database to SQL 2005. I have the odbc dsn set up and it works with Acce…

  rshaw 91433

  1 replies

  15 years, 5 months ago

  By: PaulB-TheOneAndOnly

• SQL 2008 link server failure to oracle

  Having a strange connection issue connecting to oracle from SQL 2008. Server: SQL server 2008 Versi…

  ajaffri

  1 replies

  15 years, 6 months ago

  By: sreddyv26

• List Oracle Triggers from SQL Server 2005 Linked Server

  How do I list all the triggers from: 1 - a specific table 2 - the entire database thru a linked ser…

  Bitter Monkey

  4 replies

  15 years, 6 months ago

  By: Bitter Monkey

• Rollback over linked server not working

  I am doing an BEGIN TRANSACTION in Stored Procedure in SQL 2005 I am using an OPEN QUERY Call to an…

  mhilligas

  6 replies

  15 years, 6 months ago

  By: PaulB-TheOneAndOnly

• What is Oracle DBA salary in Egypt now?

  Dears,, Please, i have a question regarding to Oracle DBA salaries . . . My courses and certificate…

  eng_mohammedmostafa

  2 replies

  15 years, 6 months ago

  By: Welsh Corgi

• strange date values

  Hi All, I am currently trying to export date like values from oracle database to sql. data in oracl…

  ziangij

  3 replies

  15 years, 7 months ago

  By: ziangij

• Creating DB link b/w Oracle and SQL server

  Hello Everyone, Here i have Oracle Database 9i and SQL Server 2005 databases. I have some tables in…

  ram_reddyprasad

  7 replies

  15 years, 7 months ago

  By: "Walkair" Steve Rezhener

• SSIS OLE DB data source query is choking Oracle 11g

  I have a set of SSIS packages which pull data from Oracle 10 into SQL Server 2005, working fine. O…

  Alan Spillert

  11 replies

  15 years, 7 months ago

  By: COZYROC

• Import Oracle dmp file to SQL2005

  Hi all, I have an Oracle dmp file and need to import and I'm looking for suggestions. So far I have…

  allen davidson

  2 replies

  15 years, 7 months ago

  By: allen davidson

• ORACLE LINKED SERVER - EXTREMELY SLOW INSERTING INTO SQL TABLE

  I am running SQL SERVER 2005 and have a LINKED SERVER to ORACLE. Using ORACLE PROVIDER FOR OLE DB. …

  corythewiz2002

  1 replies

  15 years, 7 months ago

  By: rojen83

• Transform date

  I would like to transform a date from YY-MM-DD YYYY-MM-DD 00:00:00.000. I know I have to use TRUNC(…

  mony12

  1 replies

  15 years, 7 months ago

  By: PaulB-TheOneAndOnly

• Connecting to oracle and retrieving data to store on sql server

  Hello, my requirements are to connect to oracle db and make a copy on the local sql server of 3 tab…

  evald

  2 replies

  15 years, 7 months ago

  By: evald

• Connecting to Oracle from SQL

  Hey all, I am new to the Oracle world and somewhat at a loss at what I've been reading thus far. He…

  Adam Bean

  36 replies

  15 years, 8 months ago

  By: Adam Bean

• Migration from SQL server 2000 to Oracle 10g

  Hi, Currently my application is working with SQL server 2000 database and now we are planning to mi…

  nivedita.kathal

  3 replies

  15 years, 8 months ago

  By: Martin Wills