Consultant

Nuno

<div>
<div class="content wysiwyg-content fr-view">
Hi,<br>On Sybase, we can force row-level locking for a table using this statement:<br><pre><code class="code-1 nolinks" id="code-10-29216429-1">alter table titles lock datarows</code></pre>Is there an equivalent option in Oracle ?<br><br>Thanks
</div>
</div>



Hi,
On Sybase, we can force row-level locking for a table using this statement:
alter table titles lock datarows
Is there an equivalent option in Oracle ?
Thanks

row-level locking in Oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Sybase, a subsidiary of SAP, builds a client/server relational database management system. Products include Adaptive Server Enterprise (ASE), Adaptive Server Anywhere (ASA), Sybase Unwired Platform (SUP) for mobile applications, Afaria for enterprise mobile device management and IQ for data warehouse and big data applications.

Sybase Database

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.