Moving from NT/SQL7.0 to Linux/Oracle I have encountered a few issues.
Perhaps someone can point an Oracle newbie to right solution(s).
- My database has some MS/SQL7 varbinary columns. This seems to map
to the raw datatype under Oracle? I would like to apply some
contraints to ensure that the values are only within a certain range.
SQL7 lets me define contraints which compare the values of a
varbinary(1) to constants such as 0x01. I have been able to compare
for equality under Oracle using RAWTOHEX() to get a string and compare
the string to a constant '01' but this does not work for ranges. What
is the best way to do this?
- SQL7 has an identity datatype which causes each inserted row to get
assigned a unique value. The closest thing I have found under Ora is
to define a sequence and use values from the sequence. Is this the
correct approach.
- To guard against concurrent read/update errors MS/SQL7 suggests
using adding a column type of timestamp. The timestamp column gets
updated automatically whenever anyone does a modification to the
column. Applications can tell if update collisions have occured by
adding a "where timestamp = " clause to the table update statements.
How does this work under Oracle
- MS/SQL7 has a database option (xact_abort) which controls behavior
during execution of a batch. If xact_abort is on, the entire batch is
rolled back if any of its statements fail. If xact_abort is off, only
the offending statement is rolled back but execution of the rest of the
batch continues. What option(s) control this behavior under Ora.
Thanks for any suggestions/pointers.
Jim
Received on Thu Jun 03 1999 - 07:10:45 CDT
