I would like to create a table with datarows as the default lock, how am I about to do it?
To be more specific, in Sybase I know something like the following
create table myTable (xxxxx) lock datarows
# as I understand, this sql statement will create a table with datarows locking is the chosen locking protocol.
The question is: can I have something similar to that in Oracle? What is the SQL statement?