Problem When Converting Database From Sql Server To Oracle

[hassan_amaar]

1-in sql server there is aproprty named identity that allow column value to increment automatically when we insert data into it. does you know an equvilant for it in oracle?

2-there is a datatype named uniqueidentifier(datatype not constraint) into sql server what is it's equivlent in oracle?

I will be gartefull if anyone could help me to this problem
Best regards
Hassan Amaar.

[sakr_orcl]

(1).
- Create Sequance ,
- on block , on per-insert trigger assigne value(Sequence_name.next) to the field