武道至尊帝临小说,绝色狂妃仙魅小说

主頁(yè) > 知識(shí)庫(kù) > Oracle學(xué)習(xí)筆記(五)

Oracle學(xué)習(xí)筆記(五)

組合集總計(jì)：
group by with rollup/cube
grouping sets
子查詢(xún)按執(zhí)行方式分：標(biāo)準(zhǔn)子查詢(xún)、關(guān)聯(lián)子查詢(xún)
標(biāo)準(zhǔn)子查詢(xún)：嵌套子查詢(xún)
標(biāo)量值查詢(xún)
case with then
使用exits查詢(xún)
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

插入語(yǔ)句insert statement
insert into table[(column[,column...])]
values(value[,value...])
修改語(yǔ)句update statement
update table
set column=value[,column=value,...]
[where condition];

多表插入語(yǔ)句(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
where 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
into...
select...
創(chuàng)建索引
cretate table t_10
(id number(6) not null primary key using index (create index index1 on t_10(id)),
name varchar2(50));
查詢(xún)索引
select * from user_indexes;

您可能感興趣的文章:

Oracle學(xué)習(xí)筆記(六)
Oracle學(xué)習(xí)筆記(四)
oracle學(xué)習(xí)筆記(三)
oracle學(xué)習(xí)筆記(二)
Oracle學(xué)習(xí)筆記(一)

標(biāo)簽：定西包頭溫州衢州淮北潮州衡水通遼

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《Oracle學(xué)習(xí)筆記(五)》，本文關(guān)鍵詞 Oracle,學(xué)習(xí),筆記,五,Oracle,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。

濮阳杆衣贸易有限公司

Oracle學(xué)習(xí)筆記(五)