Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Oracle to Sql server(data migration)

  As per my requirement i have to move ORACLE data (objects:tables ) to Sql server.. I shall be thank…

  geetha@in

  2 replies

  13 years ago

  By: fitsumkh

• CONVERT ORACLE FUNCTION TO SQL-SHUBHAM SAXENA @INVENTIVE INFORMATICS

  Dear Friends, I want to convert stored procedure that containg Loops ,Table valued functions,Scala…

  shubham.saxena67

  8 replies

  13 years ago

  By: PaulB-TheOneAndOnly

• Oracle SQL Plus syntax

  I'm used to SQL Server. Oracle syntax is a bit different. I have Oracle SQL Plus (v9). I've solved…

  Tom257

  5 replies

  13 years, 2 months ago

  By: Ron Warshawsky

• xlock

  Hi all, We have a select for update query in Oracle, to xlock the rows in the select statement bef…

  newbieuser

  1 replies

  13 years, 3 months ago

  By: PaulB-TheOneAndOnly

• SSIS parameters for execute sql task and oracle

  I am trying to pass parameters to in the Execute SQL Task for an Oracle query. I am running a query…

  coder_t2

  7 replies

  13 years, 3 months ago

  By: amir.mochtar

• Problems to transcript a Oracle SQL Script

  Hello together, i have problems to build a T-SQL script for MS SQL 2005, which should do the same l…

  franz.ladda

  12 replies

  13 years, 3 months ago

  By: amir.mochtar

• Oracle PL\SQL for a T-SQL Developer

  I know this is a really stupid question (given what I saw on the Oracle boards) but I am trying to …

  sbelche-760308

  12 replies

  13 years, 3 months ago

  By: clayton.mitchell

• getting data from oracle table to sql server table

  Hello, I want to read the data from a oracle db table into a sql server db table. I heard that this…

  Sachin Vaidya

  1 replies

  13 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Linked server error while excuting SQL proc

  I have a linked server connection to Oracle from SQL server. I am calling Stored procedure from St…

  ItsMeSri

  1 replies

  13 years, 4 months ago

  By: Stupeo

• Ref Cursors

  Hi All, I have a question regarding the ref cursors. Why is it required to use a ref cursor to retu…

  ssc_san

  10 replies

  13 years, 4 months ago

  By: PaulB-TheOneAndOnly

• Data needs to be transfered from SQL Server 2005 to Oracle 10g

  I am having a table in SQL server 2005 database (64-bit enterprise edition & SP3). I am having…

  DBAsql-1046554

  14 replies

  13 years, 4 months ago

  By: Bruce W Cassidy

• Insert data through View using openquery on Linked Server fails

  Hi experts, I've got an oracle linked server. In my SQL Server 2008 R2 DB i've a view pointing to a…

  sqlTobi

  3 replies

  13 years, 5 months ago

  By: PaulB-TheOneAndOnly

• Pulling data from oracle, SSIS vs OPENQUERY

  I have an interesting scenario here, I can't find what the problem is I pull data from oracle every…

  Ryan Naude

  6 replies

  13 years, 5 months ago

  By: @DJ

• Error reading string from Oracle to MS SQL 2005

  Hi all. I have set up a connection that pull data from Oracle 10.2.0. It is no problem to transfer …

  @DJ

  7 replies

  13 years, 6 months ago

  By: Source-NH

• Connectivity of Oracle Server from Windows XP and Linux?

  Hello All We have Oracle installed on Server. There are 2 OS running in the 2 network lines namely …

  sherwincurt

  3 replies

  13 years, 7 months ago

  By: PaulB-TheOneAndOnly