Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OT - Orientation for developers new to Oracle

Re: OT - Orientation for developers new to Oracle

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 21 Sep 2005 15:54:53 +0100
Message-ID: <7765c89705092107545bc1778b@mail.gmail.com>


On 9/20/05, BP <brian.peasey_at_gmail.com> wrote:
>
> Hi everyone,
>
> I'm working in a medium sized insurance company here in Canada and have
> been
> tasked to prepare and deliver 1/2 day of training for our developers
> who will be working against a new Oracle installation. Most know SQL
> and but come from a VB/SQL Server background.

  Missed out earlier some stuff that is done differently.  Sequences/artificial key generation.
bulk ops in PL/SQL.
transaction length - typically shorter than business transaction length in mssql.
temporary tables - precreate in Oracle, create in sp in sqlserver. outer joins - if they don't know the ansi syntax or you are prior to 9.2 DBMS_APPLICATION_INFO (ok I just want some developer somewhere to use this).

--

> Niall Litchfield
> Oracle DBA
> http://www.niall.litchfield.dial.pipex.com
-- http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 21 2005 - 09:57:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US