Working with Oracle

• Topics

  Started by

  Posts

  Last post

• PL/SQL After/Before Insert Trigger

  Hi iam trying to generate an after insert trigger for a student monitoring system which counts the…

  jay565260

  1 replies

  16 years, 10 months ago

  By: PaulB-TheOneAndOnly

• How to load _OraMTS_ into Oracle database

  The operation on the Oracle database machine: According to KB 193893, create two views in Oracle, p…

  245312892

  1 replies

  16 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Data types conversion in SQL and Conditional format

  Hi I would like you to help me to come up with desired results for this report.I am currently prep…

  nmxobo

  1 replies

  16 years, 10 months ago

  By: PaulB-TheOneAndOnly

• sp_executesql Equivalent in Oracle...

  Hi, Currently we are shifted on Oracle from MsSQL 2005. I want to convert a stored procedure which …

  V_Abhijit

  6 replies

  16 years, 10 months ago

  By: V_Abhijit

• Oracle books for Sql server DBA

  I need to learn more about oracle, is anyone aware of any books that is really helpful for an Sql s…

  bunmiog

  7 replies

  16 years, 10 months ago

  By: Jeff Moden

• Msg 7346, Level 16, State 2

  When I run the query with "group by" I get the error as noted below. If I remove the "group by" an…

  samiam914

  1 replies

  16 years, 10 months ago

  By: PaulB-TheOneAndOnly

• Oracle 10g versus sqlserver 2005

  We are evalauting oracle 10g versus sqlserver 2005. Our data center is set up such that automatic d…

  sarabjit-singh.bhatia

  3 replies

  16 years, 11 months ago

  By: gints.plivna

• Pivot view date - SQL vs Oracle

  Hi, I have the script in SQL Server 2005 that it works very fine as pivot, but I want to use it als…

  Dugi

  11 replies

  16 years, 11 months ago

  By: Dugi

• Data Migration from Oracle 9i to SQL Server 2005

  Hi Everyone, Can anybody explain me the process of data migration from Oracle9i to SQL server 2005?…

  Neel009

  3 replies

  16 years, 11 months ago

  By: Mohammad Mazharuddin Ehsan

• Local Instance Name

  Hi , I am new to oracle. How can i get the local instance name for oracle server. i hvae oracle ser…

  Abhijit More

  1 replies

  16 years, 11 months ago

  By: Mohammad Mazharuddin Ehsan

• WHAT IS EQUIVALENT OF ORACLE'S LOCALTIMESTAMP() IN SQL SERVER 2005

  Dear All, I need the equivalent functionality of Oracle's LOCALTIMESTAMP() in SQL Server 2005. Plea…

  sachin.s.joshi

  1 replies

  16 years, 11 months ago

  By: MarkusB

• Calling and Oracle procedure from SQL and getting back values

  Hi All, I have an SQL 2005 64-bit server. I am trying to call a procedure on an Oracle server and p…

  Schadenfreude-Mei

  8 replies

  16 years, 11 months ago

  By: samiam914

• Dataype equivalent

  Hi all, I have to create a new field in a table, the length of the values will be 1.0. I just …

  newbieuser

  2 replies

  16 years, 11 months ago

  By: newbieuser

• Run Oracle sProcs thru Linked Server?

  My customer is considering set up Linked Servers to Oracle10g to address some CLR/ADO.net problems …

  RBarryYoung

  4 replies

  16 years, 11 months ago

  By: RBarryYoung

• Sql2005-Oracle Linked Server Insert Problem

  Hi dear friends and It Professionals; We have an important and urgent problem that we have been try…

  sahinumut

  1 replies

  16 years, 11 months ago

  By: jgrubb