以下是一些Oracle数据库增删改查的例题:
例题1:
假设有一个名为employees
的表,结构如下:
CREATE TABLE employees (
id NUMBER PRIMARY KEY,
name VARCHAR2(50),
age NUMBER,
department VARCHAR2(50)
);
INSERT INTO employees (id, name, age, department) VALUES (1, 'John Doe', 30, 'HR');
SELECT * FROM employees;
SELECT * FROM employees WHERE age >= 30;
UPDATE employees SET department = 'IT' WHERE department = 'HR';
DELETE FROM employees WHERE id = 2;
例题2:
假设有一个名为products
的表,结构如下:
CREATE TABLE products (
id NUMBER PRIMARY KEY,
name VARCHAR2(100),
price NUMBER,
quantity NUMBER
);
INSERT INTO products (id, name, price, quantity) VALUES (1, 'Laptop', 1000, 50);
SELECT price FROM products;
SELECT * FROM products WHERE price > 500;
UPDATE products SET quantity = 100 WHERE quantity = 50;
DELETE FROM products WHERE id = 1;
这些例题涵盖了Oracle数据库的基本增删改查操作。通过练习这些题目,可以加深对Oracle数据库的理解和掌握。
亿速云「云数据库 MySQL」免部署即开即用,比自行安装部署数据库高出1倍以上的性能,双节点冗余防止单节点故障,数据自动定期备份随时恢复。点击查看>>
推荐阅读:oracle数据库增删改查语句是什么