PL\SQL

[ptheriault]

Can anyone recommend a really good book for PL\SQL?

 

[oradba101]

Hi, ptheriault

Oracle PL/SQL Programming
by Steven Feuerstein, Bill Pribyl
Fourth Edition August 2005

It is available at O'Reilly's website or even cheaper at

http://www.bookpool.com

Regards,


William Chadbourne
Oracle DBA

 

[ptheriault]

Thanks William.
I've been working with T-SQL and SQL server for 8 years now. But I've recently moved to a new company that has a 10G Oracle DB that we are migrating to SQL 2005. I need to re-write a lot of packages as stored procedures.

 

[LKBrwnDBA]

Migrating from Oracle to SQL 2005?

My deepest condolences, you are changing an F18 for a kite.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[oradba101]

Or a Ferrari for a yugo (doesn't deserve a capital letter)?

Regards,



William Chadbourne
Oracle DBA

 

[ptheriault]

Believe me if you saw this Oracle database that has been upgraded through the years, access would be a better solution. It is the ugliest thing I've seen. I was an import from a flat file system and they never made it relational. So I don't get any performance benefits from Oracle anyway.
Besides SQL server 2005 is more like a 747 with all its features. : )

 

[oradba101]

Due to the data layout of the system I have to report on by extracting the data into Oracle, I have one view that is a 41 table and view join.

Oracle - Suse10, 2GB RAM, Single 1800 Processor
SQL Server - MS Standard 2003, 4GB RAM, Dual Processor.

The same view runs about 25% faster on the Oracle/Linux vs. SQL Server/2003 Server. The view is optimized to run for the database/OS it needs to run on.

Regards,



William Chadbourne
Oracle DBA

 

[ptheriault]

Part of the problem here is that the Oracle db was installed on Windows. I would agree that any platform will run faster on unix\linux and it would be much more stable.

 

[oradba101]

If it were me, I would still stick with Oracle as it is certainly less hardware intensive than SQL Server is and has much better security as well. To me, security is definitely a major factor.

Regards,



William Chadbourne
Oracle DBA

 

[ptheriault]

I can't do that. I'm an MCDBA and I was hired to manage this new server. I like my job thanks. I'll get the PL\SQL book so I can re-write the packages. We'll migrate the data into our new db which I know will be a million times faster than the old server just because of how much new hardware was put in place. 64 bit os cluster on a raid 10 SAN with 32 gb of mem.
Thanks for the advise on the book.