Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Case statemants in an SQL update query

  Hi, I wanted to know what is the syntax for using case statements in an SQL update query. We are qu…

  shenyjoy

  3 replies

  16 years, 5 months ago

  By: Vijaya Kadiyala

• SQL to ORACLE Conversion

  Hi all, I am having an .Net application with its back end as SQL Server. Now we want to work with m…

  Jaya Chitra

  8 replies

  16 years, 5 months ago

  By: Vijaya Kadiyala

• create oracle database without oracle server installation

  Hi, I need a sample oracle database on my machine, but I do not have oracle server installation. Ar…

  basava_v

  2 replies

  16 years, 5 months ago

  By: Vijaya Kadiyala

• SSIS - Oracle Login Procedure

  I am writing a SSIS package and using the Oracle OLEdb connection rather then the MS one, I can que…

  ray-757028

  1 replies

  16 years, 6 months ago

  By: hmaharaj

• connect othe userthrough procedure from one user ,pass value to procedure

  How i connect to othe user inside a procedure; how i pass a table name to procedure at the time of …

  niranjan.litu

  1 replies

  16 years, 6 months ago

  By: hmaharaj

• SSIS packages - Oracle table copied to SQL Server table

  I am having a problem with an SSIS package that is trying to do a copy table from Oracle to MS-SQL …

  paul.thomas

  2 replies

  16 years, 6 months ago

  By: hmaharaj

• Select and Update a Column Value with data from another table

  Hi, I have three tables T1 has the columns Course, Site and Roomid. T2 that has the same columns.…

  shenyjoy

  1 replies

  16 years, 6 months ago

  By: Andras Belokosztolszki

• Linked Servers to an Oracle Database on a HP

  Hello, I have a SQL Server 2000 (version 8.0.2039). I am using the new MS SQL Management Studio to …

  pbyrum

  3 replies

  16 years, 6 months ago

  By: magasvs

• Oracle SSIS package

  Hi, I have a SSIS package with a connection whit ORACLE. When I am installation the package, I have…

  Victor-230790

  1 replies

  16 years, 6 months ago

  By: Gail Shaw

• getdate() in trigger

  -------------------------------------------------------------------------------- Hi all, I am tryin…

  newbieuser

  2 replies

  16 years, 6 months ago

  By: newbieuser

• The method of taking 9i OCP exams

  If you want to take 9i OCP, I have something to share with you. You must note the things that I wil…

  245312892

  2 replies

  16 years, 6 months ago

  By: 245312892

• Convert HH:MM to HHMM

  I have a field that has a varchar of data that represents the time as example ( 9:34 , 10:10 , 22:0…

  shenyjoy

  3 replies

  16 years, 7 months ago

  By: gints.plivna

• Setup TNSNames.ora and Listener.ora for Oracle 10g to Sql Server 2000 /2005 database link

  I need to set up a database link in oracle that lets me query data in sql server 2000 and sql serve…

  david_wendelken

  2 replies

  16 years, 7 months ago

  By: rlondon

• TEMPORT TABLE

  THIS DOES NOT WORK AS WELL BEGIN CREATE GLOBAL TEMPORARYTABLE ORD (ORD_NUM INT,ORD MAC INT) ON COMM…

  hmaharaj

  5 replies

  16 years, 7 months ago

  By: gints.plivna

• Linked Server in 64 bit environment using MS OLE DB Provider for Oracle

  Hi I am using LinkedServer to migrate data from Oracle 8.0 to SQL Server 2005. I am using MS OLE DB…

  m.shaw

  3 replies

  16 years, 7 months ago

  By: James Lindner