創(chuàng)建表

1、創(chuàng)建表：CREATE TABLE table_name (column1 datatype, column2 datatype, …);

創(chuàng)新互聯(lián)建站長(zhǎng)期為上千家客戶提供的網(wǎng)站建設(shè)服務(wù)，團(tuán)隊(duì)從業(yè)經(jīng)驗(yàn)10年，關(guān)注不同地域、不同群體，并針對(duì)不同對(duì)象提供差異化的產(chǎn)品和服務(wù)；打造開(kāi)放共贏平臺(tái)，與合作伙伴共同營(yíng)造健康的互聯(lián)網(wǎng)生態(tài)環(huán)境。為新區(qū)企業(yè)提供專業(yè)的成都做網(wǎng)站、成都網(wǎng)站制作，新區(qū)網(wǎng)站改版等技術(shù)服務(wù)。擁有10余年豐富建站經(jīng)驗(yàn)和眾多成功案例,為您定制開(kāi)發(fā)。

2、添加列：ALTER TABLE table_name ADD column_name datatype;

3、刪除列：ALTER TABLE table_name DROP COLUMN column_name;

4、修改列：ALTER TABLE table_name MODIFY column_name datatype;

5、重命名表：RENAME table_name TO new_table_name;

6、刪除表：DROP TABLE table_name;

插入數(shù)據(jù)

7、插入單行數(shù)據(jù)：INSERT INTO table_name (column1, column2, …) VALUES (value1, value2, …);

8、插入多行數(shù)據(jù)：INSERT ALL INTO table_name (column1, column2, …) VALUES (value1, value2, …) INTO temp SELECT column1, column2, … FROM another_table;

9、從其他表中復(fù)制數(shù)據(jù)：INSERT INTO table_name (column1, column2, …) SELECT column1, column2, … FROM another_table;

查詢數(shù)據(jù)

10、查詢所有數(shù)據(jù)：SELECT * FROM table_name;

11、查詢指定列：SELECT column1, column2, … FROM table_name;

12、查詢滿足條件的數(shù)據(jù)：SELECT * FROM table_name WHERE condition;

13、排序查詢結(jié)果：SELECT * FROM table_name ORDER BY column1 ASC/DESC;

14、分組查詢：SELECT column1, column2, … FROM table_name GROUP BY column1;

15、連接查詢：SELECT * FROM table1 INNER/LEFT/RIGHT/FULL JOIN table2 ON table1.column = table2.column;

更新數(shù)據(jù)

16、更新單行數(shù)據(jù)：UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition;

17、更新多行數(shù)據(jù)：UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition;

18、使用子查詢更新數(shù)據(jù)：UPDATE table_name SET column1 = (SELECT column1 FROM another_table WHERE condition), column2 = (SELECT column2 FROM another_table WHERE condition) WHERE condition;

刪除數(shù)據(jù)

19、刪除單行數(shù)據(jù)：DELETE FROM table_name WHERE condition;

20、刪除多行數(shù)據(jù)：DELETE FROM table_name WHERE condition;

21、刪除表中所有數(shù)據(jù)：DELETE FROM table_name;

索引和約束

22、創(chuàng)建索引：CREATE [UNIQUE] INDEX index_name ON table_name (column1, column2, …);

23、刪除索引：DROP INDEX index_name;

24、主鍵約束：ALTER TABLE table_name ADD PRIMARY KEY (column1);

25、外鍵約束：ALTER TABLE table_name ADD FOREIGN KEY (column1) REFERENCES another_table(column2);

26、NOT NULL約束：ALTER TABLE table_name ALTER COLUMN column1 NOT NULL;

27、CHECK約束：ALTER TABLE table_name ADD CONSTRAINT check_constraint check_condition;

事務(wù)處理

28、BEGIN:開(kāi)始事務(wù)處理；

29、SAVEPOINT savepoint_name:設(shè)置保存點(diǎn)；

30、ROLBACK TO savepoint_name:回滾到保存點(diǎn)；

31、COMMIT:提交事務(wù)；

32、ROLLBACK:回滾事務(wù)。

存儲(chǔ)過(guò)程和函數(shù)

33、創(chuàng)建存儲(chǔ)過(guò)程：CREATE PROCEDURE procedure_name (parameter1 datatype, parameter2 datatype, …) IS/AS BEGIN … END;

34、調(diào)用存儲(chǔ)過(guò)程：CALL procedure_name (value1, value2, …);

35、創(chuàng)建函數(shù)：CREATE [OR REPLACE] function_name (parameter1 datatype, parameter2 datatype, …) RETURN datatype IS/AS BEGIN … RETURN result; END;

36、調(diào)用函數(shù)：result := function_name (value1, value2, …);

觸發(fā)器

37、創(chuàng)建觸發(fā)器：CREATE [OR REPLACE] [TRIGGER] trigger_name {BEFORE |AFTER} {INSERT |UPDATE |DELETE} ON table_name FOR EACH row [WHEN condition] BEGIN … END;

38、刪除觸發(fā)器：DROP [TRIGGER] trigger_name;

39、禁用觸發(fā)器：DISABLE [TRIGGER] trigger_name;

40、啟用觸發(fā)器：ENABLE [TRIGGER] trigger_name;

視圖和物化視圖

41、創(chuàng)建視圖：CREATE [OR REPLACE] [VIEW] view_name AS select_statement;

42、刪除視圖：DROP [VIEW] view_name;

43、創(chuàng)建物化視圖：CREATE MATERIALIZED [VIEW] view_name [WITH NOCACHE] AS select_statement;

44、刪除物化視圖：DROP MATERIALIZED [VIEW] view_name;

45、刷新物化視圖：REFRESH MATERIALIZED [VIEW] view_name [COMPLETE|FORCE];

新聞名稱：Oracle50條語(yǔ)句突破技術(shù)邊界
分享路徑：http://uogjgqi.cn/article/cojiidj.html