当涉及到 Oracle 数据库的基本语句时,以下是一些常用的语句和操作:
创建表:
CREATE TABLE table_name (
column1 datatype constraint,
column2 datatype constraint,
…
);
插入数据:
INSERT INTO table_name (column1, column2, …)
VALUES (value1, value2, …);
查询数据:
SELECT column1, column2, …
FROM table_name
WHERE condition;
删除数据
DELETE FROM table_name
WHERE condition;
创建索引:
CREATE INDEX index_name
ON table_name (column1, column2, …);
创建视图:
CREATE VIEW view_name AS
SELECT column1, column2, …
FROM table_name
WHERE condition;
创建存储过程:
CREATE PROCEDURE procedure_name
(parameter1 datatype, parameter2 datatype, …)
AS
BEGIN
– Procedure logic here
END;
创建触发器:
CREATE TRIGGER trigger_name
BEFORE INSERT OR UPDATE OR DELETE ON table_name
FOR EACH ROW
BEGIN
– Trigger logic here
END;
创建数据库用户:
CREATE USER username IDENTIFIED BY password;
授予用户权限:
GRANT privilege_name1, privilege_name2, …
TO username;
撤销用户权限:
REVOKE privilege_name1, privilege_name2, …
FROM username;
修改表结构(添加列):
ALTER TABLE table_name
ADD column_name datatype;
修改表结构(修改列):
ALTER TABLE table_name
MODIFY column_name datatype;
修改表结构(删除列):
ALTER TABLE table_name
DROP COLUMN column_name;
模糊查询:
SELECT column1, column2, …
FROM table_name
WHERE column_name LIKE pattern;
排序查询结果:
SELECT column1, column2, …
FROM table_name
ORDER BY column_name [ASC|DESC];
子查询:
SELECT column1, column2, …
FROM table_name
WHERE column_name IN (SELECT column_name FROM another_table);
分组查询:
SELECT column1, aggregate_function(column2), …
FROM table_name
GROUP BY column1;