lock table table_name in row exclusive mode nowait;

lock table table_name in share row exclusive mode;

lock table table_name in row share mode nowait;