Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Help me understand this

  DECODE(addr.pk_dynreport.f_chk_omit('ccard_auto_renew'),'Y', NULL, circ.subs_bill_util.ccard_status…

  varunkum

  3 replies

  13 years, 7 months ago

  By: Vedran Kesegic

• how to install oracle client and ODAC 11g on sql server 2005 cluster 32 bit

  Hi all, Has anyone ever installed oracle client and ODAC 11g on sql server 2005 cluster 32 bit? …

  binary83

  3 replies

  13 years, 7 months ago

  By: Tracy S Sells

• Trying to connect SQL Server 2008 64-bit to Oracle 10g

  I have a need to connect a linked server to an instance of Oracle 10g on my Windows 64-bit instance…

  Aaron N. Cutshall

  25 replies

  13 years, 7 months ago

  By: Syed Jahanzaib Bin hassan

• Sql query on orcale DB error (literal does not match format string)

  select a,b,c,d,e, ADDED_DATE, CLIENT_TYPE from table1(orcaletable) where CLIENT_TYPE <> 4 and…

  quillis131

  3 replies

  13 years, 7 months ago

  By: PaulB-TheOneAndOnly

• Mon-Thu group by

  Hi i have a table with "Class", "Dates" and "Copies". Now i want sum of all copies for a distinct c…

  varunkum

  1 replies

  13 years, 8 months ago

  By: PaulB-TheOneAndOnly

• DELETE OPENQUERY Error

  I have a situation where I want to delete some records on a Oracle DB from a SQL Server DB via a li…

  abotha-1117340

  4 replies

  13 years, 8 months ago

  By: alexsmth114

• code help needed

  Below is the result i get for the query below assuming a matrix report. Only the codes that have c…

  varunkum

  4 replies

  13 years, 8 months ago

  By: Jeff Moden

• Help with the sql

  I want to take off the repeating DISPLAY_NAME 's, i only want the distinct one's. Someone please h…

  varunkum

  4 replies

  13 years, 9 months ago

  By: alexsmth114

• fastest way to export from Oracle into textfiles

  I'm working with some Oracle 9i database servers, and I need to export some fairly large tables fro…

  sqltung

  16 replies

  13 years, 9 months ago

  By: alexsmth114

• How do I update an Oracle table using SSIS from a flat file source

  Hello, I got SSIS 64 bits working to connect to a 32 bits database and now I'm toying with this. I'…

  Resender

  3 replies

  13 years, 10 months ago

  By: Resender

• Help an Oracle newbie out

  Hello, In the past 3 years, since graduation college, my carreer as a dba/programmer has been compl…

  Resender

  43 replies

  13 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Urgent, Pumping data from Oracle 32 bits to SQL Server 2008 (64 bits) using SSIS

  Hello, We got this problem yesterday and have not been able to solve it. Yesterday our company got …

  Resender

  13 replies

  13 years, 10 months ago

  By: Resender

• Help Needed To Install Oracle 11g on SUSE11 32 bits Linux

  Hello all, I got a SUSE Linux 32 bits virtual machine running on my server and would like to instal…

  Resender

  2 replies

  13 years, 10 months ago

  By: Resender

• Integration Service and Oracle 8 whit ODBC connection

  Integration Service and Oracle 8 whit ODBC connection Work on Integration Service but does not work…

  mysaes_jgo

  4 replies

  13 years, 10 months ago

  By: mysaes_jgo

• Dates

  Please tell me the appropriate where condition with dates in oracle select * from table_name where …

  varunkum

  2 replies

  13 years, 10 months ago

  By: PaulB-TheOneAndOnly