Skip to primary navigation
Skip to main content
Skip to primary sidebar
Skip to secondary sidebar

Home
HTML
CSS
PHP
SQL
MySQL
JS
PL/SQL
Python
Java
Oracle

PL/SQL Set Transaction

Oracle PL/SQL Set Transaction Example

COMMIT; 

SET TRANSACTION READ ONLY NAME 'London'; 

SELECT customer_id, city FROM customers

WHERE customer_id = 1; 


COMMIT;

Filed Under: PL/SQL

Primary Sidebar

Search this website

Tutorials

HTML Tutorial
CSS Tutorial
PHP Tutorial
SQL Tutorial
MySQL Tutorial
JavaScript Tutorial
Python Tutorial
PL/SQL Tutorial
Java Tutorial
SQLPlus Tutorial
Oracle Tutorial
PostgreSQL Tutorial
Ruby Tutorial

Secondary Sidebar

Recent Posts

PostgreSQL ERROR: cannot begin/end transactions in PL/pgSQL
PostgreSQL Column must appear in the GROUP BY clause
PostgreSQL Column specified more than once
PostgreSQL Create database, Alter database examples
PostgreSQL Create schema syntax, Alter schema
PostgreSQL Create database user, alter and drop username
PostgreSQL Alter table name. Modify column name
PostgreSQL Alter Function Examples
PostgreSQL Drop function syntax and example
PostgreSQL Alter Trigger, Disable trigger, enable
PostgreSQL Drop Trigger, syntax and example
PostgreSQL Create table type, alter and drop type
PostgreSQL Loop – End Loop
PostgreSQL Case – When – Then
PostgreSQL IF – Elsif – Else syntax
PostgreSQL IF – Then – Else syntax
PostgreSQL IF – Then syntax
PostgreSQL Control Structures syntax: if then else case
PostgreSQL Alter table add primary key to existing table
PostgreSQL Alter table add foreign key constraint to a table
PostgreSQL Alter table add unique key constraint to a table
PostgreSQL Alter table add column to existing table
PostgreSQL Alter table add multiple columns to existing table
PostgreSQL Alter table drop column from existing table
PostgreSQL Alter table drop multiple columns from table
PostgreSQL Alter table rename column from existing table
PostgreSQL Alter table rename table name
PostgreSQL Alter table add check constraint to a table
PostgreSQL Alter table drop check constraint from a table
PostgreSQL tutorial. Error messages help: cause and solution.

Copyright 2018 - 2021 Coder Tutorial

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settings ACCEPT

Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

Necessary

Always Enabled

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Non-necessary

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.