Show Menu
Cheatography
  1. Home >
  2. Programming >

Oracle Database CRUD Cheat Sheet (DRAFT) by

Create, Retrieve, Update and Delete in Oracle Database

This is a draft cheat sheet. It is a work in progress and is not finished yet.

CREATE TABLE

CREATE TABLE table_name (
CREATE TABLE student (
field_1 data_type,
id NUMBER,
field_2 data_type);
name VARCHA­R2(­50));

INSERT

INSERT
INSERT INTO table_name (field1, filed2)
 
VALUES­(fi­eld­1_v­alue, field2­_va­lue);

SELECT

SELECT
SELECT field1, field2..... FROM table_name
 
WHERE condition ;

UPDATE

UPDATE
UPDATE table_name
 
SET field_name = new_value
 
WHHERE condition ;

DELETE

DELETE
DELETE FROM table_name
 
WHERE condition ;