建站
咨詢
售后
建站咨詢
新聞中心
創(chuàng)建表
1、創(chuàng)建表：CREATE TABLE table_name (column1 datatype, column2 datatype, …);
創(chuàng)新互聯(lián)建站長期為上千家客戶提供的網(wǎng)站建設(shè)服務(wù)，團隊從業(yè)經(jīng)驗10年，關(guān)注不同地域、不同群體，并針對不同對象提供差異化的產(chǎn)品和服務(wù)；打造開放共贏平臺，與合作伙伴共同營造健康的互聯(lián)網(wǎng)生態(tài)環(huán)境。為新區(qū)企業(yè)提供專業(yè)的成都做網(wǎng)站、成都網(wǎng)站制作，新區(qū)網(wǎng)站改版等技術(shù)服務(wù)。擁有10余年豐富建站經(jīng)驗和眾多成功案例,為您定制開發(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:開始事務(wù)處理；
29、SAVEPOINT savepoint_name:設(shè)置保存點；
30、ROLBACK TO savepoint_name:回滾到保存點；
31、COMMIT:提交事務(wù)；
32、ROLLBACK:回滾事務(wù)。
存儲過程和函數(shù)
33、創(chuàng)建存儲過程：CREATE PROCEDURE procedure_name (parameter1 datatype, parameter2 datatype, …) IS/AS BEGIN … END;
34、調(diào)用存儲過程：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條語句突破技術(shù)邊界
分享鏈接：http://m.fisionsoft.com.cn/article/cojiidj.html
