Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Date Variable in Oracle

  Hello, I need help to write the following query in Oracle. It seems straightforward, however, I am …

  touchmeknot

  6 replies

  13 years, 7 months ago

  By: Welsh Corgi

• Dataware House, Data mining and OLAP?

  Hello can any one tell me waht is mean by Dataware House, Data mining and OLAP?

  sherwincurt

  4 replies

  13 years, 7 months ago

  By: PaulB-TheOneAndOnly

• SSIS - Error on Date conversion

  HI all, i'm building a SSIS package to import data from Oracle 8 to sql 2005. I'm importing about 8…

  CS-1058423

  2 replies

  13 years, 7 months ago

  By: CS-1058423

• Oracle ODBC connection and 'Force Encryption' on SQL Server

  I've set up an Oracle Gateway server to connect my Oracle databases to my SQL Server databases but …

  SQLDCH

  3 replies

  13 years, 8 months ago

  By: dyun

• SQL Server to Oracle 9i Linked Server - From Remote Desktop

  Running a query from SSMS against an Oracle 9i Linked Server on this developers desktop everything …

  JeridA

  2 replies

  13 years, 8 months ago

  By: JeridA

• TOP 1000 in Oracle

  I need to query a production Oracle 9i database. I will be selecting all columns from a table that …

  sqltung

  7 replies

  13 years, 8 months ago

  By: sqltung

• declaring global variables

  Hi, In Oracle, we can set the public variable/constant/types/curosors in the Package specification,…

  BeginnerBug

  2 replies

  13 years, 8 months ago

  By: Vedran Kesegic

• delete OPENQUERY only successful the second time executed

  I have a linked server from SQL Server 2005 to an Oracle database using Oracle Provider for OLE DB.…

  karen.rogers

  2 replies

  13 years, 8 months ago

  By: Vedran Kesegic

• SSIS\SQL Agent\Oracle job not running

  We are having a problem running an SSIS package from SQL Agent. The package connects to an Oracle 1…

  Dale Lanz

  2 replies

  13 years, 9 months ago

  By: Dale Lanz

• Getting an error on every tuesday

  Hi all, We have a job that is being run for the past 4 years and it never failed due to this reason…

  srilu_bannu

  3 replies

  13 years, 9 months ago

  By: Steffen-718955

• need help with sql query against oracle database

  Hi All, I have a .NET app and the app uses a Oracle Db.So i'm using Oracle .Net Provider for .…

  Patrick.I

  1 replies

  13 years, 9 months ago

  By: PaulB-TheOneAndOnly

• How do I connect to a Oracle server via SQL Server

  What are the steps to connect from SQL Server 2008 to Oracle DB and once connected can you query th…

  Mark F-428640

  3 replies

  13 years, 10 months ago

  By: LutzM

• 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

  13 years, 11 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 ago

  By: coder_t2

• Working with Oracle

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

  chakrapanishroff

  5 replies

  14 years ago

  By: PaulB-TheOneAndOnly