Re: VARCHAR2 storage on a page

I can't wait to see Dan's reply to this.

I can't speak for Informix but the example I use when talking about porting code between platforms consists of porting the following Oracle code to MSSQL. update emp set sal = sal * 1.05;
insert into emp_audit(change_date,change_desc) values (sysdate,'Annual Salary increase all staff 5%');
commit;

which is fairly self explanatory.

In MSSQL if , for example, the insert fails then the update will be made without having being logged.

I don't think that it is unreasonable to assume that the above will be processed the same in different databases, but it won't be.

In addition I would guess that the OP is making the correct, but misleading assumption that Oracle like Informix has a fixed page/block size. The Oracle block size is only fixed at database creation it is not dictated by the underlying platform. (and in 9i you can subsequently create tablespaces with different block sizes from the database block size).

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************


"Pablo Sanchez" <pablo_at_dev.null> wrote in message
news:VxWB8.250$m5.53522_at_news.uswest.net...


>

> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message

> news:3CD8177A.39ED8EA_at_exesolutions.com...

> > But this might be a good time to point out that much of your

> > experience with Informix will likely lead you to make assumptions

> about

> > Oracle that are not valid. And those assumptions can lead to corrupt

> data,

> > lack of scalability, and other less than innocuous problems.

>

> Would you expand on the above?  In particular, what Informix

> experiences will likely lead to invalid assumptions about Oracle?

> Also, which assumptions can lead to corrupt data, etc.

>

> Thx!

> --

> Pablo Sanchez, High-Performance Database Engineering

> mailto:pablo_at_hpdbe.com

> http://www.hpdbe.com

> Available for short-term and long-term contracts

>

>

>

>