Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Query with variable for "any letter"

  Hello, I am actually setting up a wizard function on an oracle database (this wasn´t part of the jo…

  batistuta789

  3 replies

  13 years, 3 months ago

  By: Lowell

• Working with unicode (UTF-8)

  We have a large amount of jobs that take data from our Oracle database, transform it, and then impo…

  schep021

  2 replies

  13 years, 4 months ago

  By: Jo Pattyn

• Error:Right Parenthesis is required in Oracle Toad.

  string str3 = "SELECT a.siebleloginid, a.employee, MAX (a.tierlevel) AS tier FROM"+ …

  swainsarada

  3 replies

  13 years, 6 months ago

  By: PaulB-TheOneAndOnly

• 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, 6 months 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, 6 months 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, 9 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, 9 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, 9 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, 9 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, 9 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, 10 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, 10 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, 11 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, 11 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, 11 months ago

  By: PaulB-TheOneAndOnly