CREATE TABLE CONTACTS (
NAME VARCHAR2(255),
SURNAME VARCHAR2(255),
CITY VARCHAR2(255),
COUNTRY VARCHAR2(255)
)
INSERT INTO CONTACTS (NAME, SURNAME, CITY, COUNTRY) VALUES ('Bond', 'Peter', 'London', 'UK')
COMMIT
SELECT *
FROM CONTACTS
NAME | SURNAME | CITY | COUNTRY | Bond | Peter | London | UK |
---|
UPDATE CONTACTS
SET surname = 'James'
SELECT * FROM CONTACTS
NAME | SURNAME | CITY | COUNTRY | Bond | James | London | UK |
---|
DELETE FROM CONTACTS
SELECT * FROM CONTACTS
ROLLBACK
SELECT * FROM CONTACTS
NAME | SURNAME | CITY | COUNTRY | Bond | Peter | London | UK |
---|