Working with Oracle

• Topics

  Started by

  Posts

  Last post

• OraOLEDB.Oracle Connection

  I had a nightly SSIS package running on Server 2008 R2 that used the Oracle Provider for Ole DB. W…

  keith_stramler

  3 replies

  11 years, 9 months ago

  By: Jo Pattyn

• Parent to Child and subchilds

  Hi All, I need an urgent help to build some logic in Oracle DB. I have a table called TREE and in t…

  anilkumar04_b

  2 replies

  11 years, 9 months ago

  By: Jeff Moden

• How to get all Childs and subchilds of a parent

  Hi All, I need an urgent help to build some logic in Oracle DB. I have a table called TREE and in t…

  anilkumar04_b

  1 replies

  11 years, 9 months ago

  By: Sean Lange

• What is the syntax for querying an oracle linked table in access 2007

  I have an oracle linked table in an access 2007 database that is linked via an odbc connection. I h…

  lewis.ray

  4 replies

  11 years, 9 months ago

  By: PaulB-TheOneAndOnly

• how to view a Oracle stored procedure result set in sql developer?

  Hi, Sorry coming from the SQL world something as easy as highlighting the sp name and viewing the r…

  JP10

  2 replies

  11 years, 10 months ago

  By: JP10

• Cannot connect oracle 8 client on Windows 7 to and oracle database.

  Hey Guys, I am having a problem connecting to an oracle database using oracle8 client. It is instal…

  lewis.ray

  2 replies

  11 years, 10 months ago

  By: lewis.ray

• After Insert trigger

  Hi , I have a requirement where i have a table (EMP) with fields id, name, status What i want is af…

  rajasekhar.cn

  1 replies

  11 years, 10 months ago

  By: Jo Pattyn

• Oracle 9i to sql server 2008 migration

  I want to migrate from Oracle 9i to Sql server 2008 using SSMA. Please let me know what steps will …

  nitin.varshneya

  1 replies

  11 years, 10 months ago

  By: Mohammad Mazharuddin Ehsan

• Data transport from SQL Server to Oracle

  Hi, I want to export some tables from sql server 2008 to oracle 11g. I am planning to use SQL Serve…

  lg123

  2 replies

  11 years, 10 months ago

  By: lg123

• How do I search by DATE then TIME in Oracle?

  I have a query that pulls back both a Time and a Date column. I'm trying to figure out how I can se…

  jess.

  1 replies

  11 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Oracle CASE statement into SQL Server

  I'm working on changing an Oracle CASE statement into a SQL Server CASE statement. I having a spot …

  SqlHomebrewer

  1 replies

  11 years, 10 months ago

  By: SqlHomebrewer

• Converting an ORACLE function into a SQL Server function

  I've migrated some Oracle databases into some SQL Server databases and now I'm working on building …

  SqlHomebrewer

  3 replies

  11 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Need help - MS SQL Trigger for Oracle insert

  Hi, is it possible to use a ms sql trigger to insert a row in Oracle Table ? I use this way an get …

  xoom

  8 replies

  11 years, 10 months ago

  By: xoom

• Performance of a Query : which one is giving good performace

  Hi Please help me... I want join 4 tables in the Oracle.Table 1 is having 4 different where conditi…

  Raghu.K

  4 replies

  11 years, 10 months ago

  By: PaulB-TheOneAndOnly

• where to find dbservername when connecting to oracle from asp.net

  hello i have a rather novice question but i cant figure it out myself. when i try to modify web.con…

  lamiajoyee

  1 replies

  11 years, 10 months ago

  By: Jo Pattyn