導(dǎo)讀:1建站知識(shí)最近需要用的oracle，所以大家好好的學(xué)習(xí)下基礎(chǔ)并整理下資料，希望能幫助到需要的朋友。seo網(wǎng)站關(guān)鍵詞優(yōu)化網(wǎng)站建設(shè)教程。

組合集總計(jì)： group by with rollup/cube grouping sets 子查詢按執(zhí)行方式分：標(biāo)準(zhǔn)子查詢、關(guān)聯(lián)子查詢 標(biāo)準(zhǔn)子查詢：嵌套子查詢 標(biāo)量值查詢 case with then 使用exits查詢 select user_id,user_name from tb_001 tb where [not] exists (select 'x' from tb_001 where manager_id=tb.user_id ) 關(guān)聯(lián)更新 update table1 alias1 set column=(select expression from table2 alias2 where alias1.column=alias2.column); 關(guān)聯(lián)刪除 delete from table1 alias11 where column operator (select expression from table2 alias2 where alias1.column=alias2.column); 分層結(jié)構(gòu) 分層檢索 select [level],column,expr... from table [where with condition(s)] [connect by prior condition(s)] connect by prior column1=column2 top down: colum1=parentkey column2=childkey bottom up: column1=childkey column2=parentkey 插入語句insert statement insert into table[(column[,column...])] values(value[,value...]) 修改語句update statement update table set column=value[,column=value,...] [where condition]; 多表插入語句(Multitable Insert Statements) insert [all] [conditional_insert_clause] [insert_into_cause values_clause](subquery) conditional_insert_clause [all][first] [when condition then][insert_into_clause values_clause] [else][insert_into+clause values_clause] 列： intsert all into tb_user values(id,uid,upwd) into tb_user_info values(id,name,sex,age) select id,uid,upwd,name,sex,age from tb_u_10 w網(wǎng)站seo優(yōu)化培訓(xùn)here id>10000; 待條件的多行插入 insert all when id>11000 then into tb_user values(id,uid,upwd) when age>40 then into tb_user_info values(id,name,sex,age) select id,uid,upwd,name,sex,age from tb_u_10 where id>10000; insert first when conditional then into ... when conditional then into ... else in個(gè)業(yè)網(wǎng)站建設(shè)公司to... select... 創(chuàng)建索引 cretate table t_10 (id number(6) notseo網(wǎng)站排名優(yōu)化軟件 null primary key using index (create index index1 on t_10(id)), name varchar2(50)); 查詢索引 select * from user_indexes;相關(guān)seo網(wǎng)站關(guān)鍵詞優(yōu)化網(wǎng)站建設(shè)教程。

關(guān)鍵詞標(biāo)簽: 標(biāo)簽 學(xué)習(xí)筆記