Working with Oracle

• Topics

  Started by

  Posts

  Last post

• Merge in stored procedure

  Hello guys, may you help me why my merge in stored procedure have exception? CREATE OR REPLACE PRO…

  masoudk1990

  4 replies

  10 years, 4 months ago

  By: Luis Cazares

• create Linked Server to Oracle DB - Is this TSQL Script correct? - Novice

  Installed the Oracle 11g client on the SQL Server 2010 server. Using the Select Directory Server -…

  Mile Higher Than Sea Level

  3 replies

  11 years, 2 months ago

  By: Mile Higher Than Sea Level

• Query to get related Table name from given Column name in Oracle SQL Developer

  Hi ALL, I am familiar with the SQL server 2008 R2 , but when it comes to the SQL developer i am no…

  Guitar_player

  5 replies

  11 years, 4 months ago

  By: Guitar_player

• "ORA-04091" Mutating Error

  ora

  Minnu

  10 replies

  11 years, 5 months ago

  By: PaulB-TheOneAndOnly

• mutation in Trigger

  Hi Team, Am a sql developer and new to oracle, i was assinged a trigger for am having two tables Ta…

  Minnu

  2 replies

  11 years, 8 months ago

  By: Minnu

• Learning Oracle

  Found some resources, SQL Reference Guide for Oracle 10g. Guess what, Oracle actually has CTE's, t…

  Lynn Pettis

  50 replies

  11 years, 9 months ago

  By: Eric M Russell

• Error converting data type DBTYPE_DBTIMESTAMP to datetime

  Good afternoon: There is a process that somestimes fails with the error: Error converting data type…

  pavargasq

  1 replies

  12 years, 2 months ago

  By: mark johnson-159789

• Datetime Formating -

  hi, - how to get the Last 30 days records from a table in Oracle if the column is in format string …

  John Paul-702936

  2 replies

  13 years, 3 months ago

  By: PaulB-TheOneAndOnly

• Cursor use in Oracle

  Hi, I am newbie in oracle. Should we use cursor in oracle store procedure either in select statemen…

  pandeharsh

  10 replies

  13 years, 6 months ago

  By: Jeff Moden

• INVENTORY ONE TABLE CREATE HOW TO BALANCE QTY CARRY IN NEXT ROW

  MY DATE ITEM_NAME , CODE , DATE , OB_QTY , RECD_QTY , ISSUE_QTY …

  vpatil_vsp

  1 replies

  13 years, 9 months ago

  By: Lowell

• Oracle BLOB to SQL Server 2000 ntext

  Hi. I'm wondering how I go about importing data from an Oracle BLOB (holds XML) into a SQL Server 2…

  david.buncle

  1 replies

  13 years, 12 months ago

  By: afrazier-794137

• Oracle Question

  For those watching this forum for Oracle questions, I have one here.

  Lynn Pettis

  1 replies

  14 years, 1 month ago

  By: PaulB-TheOneAndOnly

• System Tables in Oracle 10g

  We all know that in SQL Server that there is a system table that tells you about all the columns in…

  Lynn Pettis

  4 replies

  14 years, 1 month ago

  By: PaulB-TheOneAndOnly

• Locking in oracle

  hi I have a select statement in sql 2000, with the select on a linked server (oracle) table. For ex…

  qaz123 90964

  1 replies

  14 years, 1 month ago

  By: PaulB-TheOneAndOnly

• Openquery from Sql Server 2003 to Oracle

  Hi All, I am working on a task, where I am connecting to Oracle database to update a row from SQL s…

  gprasanna

  2 replies

  14 years, 4 months ago

  By: gprasanna