【正文】 stocknumber between 20 and 100stocknumber in(10,20,30)order by stockid desc(asc) 排序，desc降序，asc升序order by 1,2 by列號stockname = (select stockname from stock_information where stockid = 4) 子查詢 除非能確保內(nèi)層select只返回一個行的值， 否則應(yīng)在外層where子句中用一個in限定符select distinct column_name form table_name distinct指定檢索獨有的列值，不重復(fù)select stocknumber ,stocknumber + 10 = stocknumber + 10 from table_nameselect stockname , stocknumber = count(*) from table_name group by stockname group by 將表按行分組,指定列中有相同的值having count(*) = 2 having選定指定的組select *from table1, table2where *= 左外部連接，table1中有的而table2中沒有得以null表示 =* 右外部連接select stockname from table1union [all] union合并查詢結(jié)果集，all保留重復(fù)行select stockname from table2***insert***insert into table_name (Stock_name,Stock_number) value (xxx,xxxx)value (select Stockname , Stocknumber from Stock_table2)value為select語句***update***update table_name set Stockname = xxx [where Stockid = 3]Stockname = defaultStockname = nullStocknumber = Stockname + 4***delete***delete from table_name where Stockid = 3truncate table_name 刪除表中所有行，仍保持表的完整性drop table table_name 完全刪除表***alter table*** 修改數(shù)據(jù)庫表結(jié)構(gòu)alter table add column_name char(2) null .....sp_help table_name 顯示表已有特征create table table_name (name char(20), age smallint, lname varchar(30))insert into table_name select ......... 實現(xiàn)刪除列的方法（創(chuàng)建新表）alter table table_name drop constraint Stockname_default 刪除Stockname的default約束統(tǒng)計函數(shù)AVG 求平均值COUNT 統(tǒng)計數(shù)目MAX 求最大值MIN 求最小值SUM 求和AVGuse panguselect avg(e_wage) as dept_avgWagefrom employeegroup by dept_idMAX求工資最高的員工姓名use panguselect e_namefrom employeewhere e_wage =(select max(e_wage)from employee)STDEV()STDEV()函數(shù)返回表達(dá)式中所有數(shù)據(jù)的標(biāo)準(zhǔn)差STDEVP()STDEVP()函數(shù)返回總體標(biāo)準(zhǔn)差VAR()VAR()函數(shù)返回表達(dá)式中所有值的統(tǒng)計變異數(shù)VARP()VARP()函數(shù)返回總體變異數(shù)算術(shù)函數(shù)/***三角函數(shù)***/SIN(float_expression) 返回以弧度表示的角的正弦COS(float_expression) 返回以弧度表示的角的余弦TAN(float_expression) 返回以弧度表示的角的正切COT(float_expression) 返回以弧度表示的角的余切/***反三角函數(shù)***/ASIN(float_expression) 返回正弦是FLOAT 值的以弧度表示的角ACOS(float_expression) 返回余弦是FLOAT 值的以弧度表示的角ATAN(float_expression) 返回正切是FLOAT 值的以弧度表示的角ATAN2(float_expression1,float_expression2)返回正切是float_expression1 /float_expression2的以弧度表示的角DEGREES(numeric_expression)把弧度轉(zhuǎn)換為角度返回與表達(dá)式相同的數(shù)據(jù)類型可為INTEGER/MONEY/REAL/FLOAT 類型RADIANS(numeric_expression) 把角度轉(zhuǎn)換為弧度返回與表達(dá)式相同的數(shù)據(jù)類型可為INTEGER/MONEY/REAL/FLOAT 類型EXP(float_expression) 返回表達(dá)式的指數(shù)值LOG(float_expression) 返回表達(dá)式的自然對數(shù)值LOG10(float_expression)返回表達(dá)式的以10 為底的對數(shù)值SQRT(float_expression) 返回表達(dá)式的平方根/***取近似值函數(shù)***/CEILING(numeric_expression) 返回=表達(dá)式的最小整數(shù)返回的數(shù)據(jù)類型與表達(dá)式相同可為INTEGER/MONEY/REAL/FLOAT 類型FLOOR(numeric_expression) 返回=表達(dá)式的最小整數(shù)返回的數(shù)據(jù)類型與表達(dá)式相。or stocknumber 1000and stockindex = 24not stock*** = 39。 (^排除指定范圍) 只能在使用like關(guān)鍵字的where子句中使用通配符)or stockpath = 39。 ([]指定值的范圍)stockname like 39。stockname like 39。stockname like 39。CASEuse panguupdate employeeset e_wage =casewhen job_level = ’1’ then e_wage*when job_level = ’2’ then e_wage*when job_level = ’3’ then e_wage*else e_wage*endWHILE CONTINUE BREAKdeclare x int y int c intselect x = 1 y=1while x 3beginprint x 打印變量x 的值while y 3beginselect c = 100*x + yprint c 打印變量c 的值select y = y + 1endselect x = x + 1select y = 1endWAITFOR例 等待1 小時2 分零3 秒后才執(zhí)行SELECT 語句waitfor delay ’01:02:03’select * from employee例 等到晚上11 點零8 分后才執(zhí)行SELECT 語句waitfor time ’23:08:00’select * from employee***SELECT***select *(列名) from table_name(表名) where column_name operator valueex:(宿主)select * from stock_information where stockid = str(nid)stockname = 39。else print 39。else if y zprint 39。 打印字符串39。全局變量必須以開頭IF ELSEdeclare x int y int z intselect x = 1 y = 2 z=3if x yprint 39。select id = 39。 762. ifile類似于c語言里的include，用于把另一個文件引入 763. spfile是9i里新增的并且是默認(rèn)的參數(shù)文件，二進(jìn)制格式 764. startup后應(yīng)該只可接pfileSQL語句大全語 句 功 能數(shù)據(jù)操作SELECT 從數(shù)據(jù)庫表中檢索數(shù)據(jù)行和列INSERT 向數(shù)據(jù)庫表添加新數(shù)據(jù)行DELETE 從數(shù)據(jù)庫表中刪除數(shù)據(jù)行UPDATE 更新數(shù)據(jù)庫表中的數(shù)據(jù)數(shù)據(jù)定義CREATE TABLE 創(chuàng)建一個數(shù)據(jù)庫表DROP TABLE 從數(shù)據(jù)庫中刪除表ALTER TABLE 修改數(shù)據(jù)庫表結(jié)構(gòu)CREATE VIEW 創(chuàng)建一個視圖DROP VIEW 從數(shù)據(jù)庫中刪除視圖CREATE INDEX 為數(shù)據(jù)庫表創(chuàng)建一個索引DROP INDEX 從數(shù)據(jù)庫中刪除索引CREATE PROCEDURE 創(chuàng)建一個存儲過程DROP PROCEDURE 從數(shù)據(jù)庫中刪除存儲過程CREATE TRIGGER 創(chuàng)建一個觸發(fā)器DROP TRIGGER 從數(shù)據(jù)庫中刪除觸發(fā)器CREATE SCHEMA 向數(shù)據(jù)庫添加一個新模式DROP SCHEMA 從數(shù)據(jù)庫中刪除一個模式CREATE DOMAIN 創(chuàng)建一個數(shù)據(jù)值域ALTER DOMAIN 改變域定義DROP DOMAIN 從數(shù)據(jù)庫中刪除一個域數(shù)據(jù)控制GRANT 授予用戶訪問權(quán)限D(zhuǎn)ENY 拒絕用戶訪問REVOKE 解除用戶訪問權(quán)限事務(wù)控制COMMIT 結(jié)束當(dāng)前事務(wù)ROLLBACK 中止當(dāng)前事務(wù)SET TRANSACTION 定義當(dāng)前事務(wù)數(shù)據(jù)訪問特征程序化SQLDECLARE 為查詢設(shè)定游標(biāo)EXPLAN 為查詢描述數(shù)據(jù)訪問計劃OPEN 檢索查詢結(jié)果打開一個游標(biāo)FETCH 檢索一行查詢結(jié)果CLOSE 關(guān)閉游標(biāo)PREPARE 為動態(tài)執(zhí)行準(zhǔn)備SQL 語句EXECUTE 動態(tài)地執(zhí)行SQL 語句DESCRIBE 描述準(zhǔn)備好的查詢局部變量declare id char(10)set id = 39。752.753.754. 99. 怎樣判斷數(shù)據(jù)庫是運行在歸檔模式下還是運行在非歸檔模式下？755.756. 進(jìn)入dbastudio，歷程〉數(shù)據(jù)庫〉歸檔查看。737.738.739. 96. 如何取得命令的返回狀態(tài)值？740.741. sqlcode=0742.743.744. 97. 如何知道用戶擁有的權(quán)限?745.746. SELECT * FROM dba_sys_privs 。)。),39。,39。)+rownum1 730. from all_objects 731. where rownum = to_char(to_date(39。,39。 728. insert into BSYEAR 729. select to_date(39。)。,39。716.717. 改大行，改小不行（除非都是空的）718.719.720. 93. 如何查詢某天的數(shù)據(jù)?721.722. select * from table_name where trunc(日期字段)＝to_date(39。705.706. OR707.708. SQLSELECT * FROM v$filestat 。698.699.700. 91. 怎樣估算SQL執(zhí)行的I/O數(shù) ?701.702. SQLSET AUTOTRACE ON 。694.695. SQLselect * from table。687.688. SELECT COL1||COL2 FROM TABLE 。) FROM DUAL。 680.681. SELECT ASCII(39。663.664. SQLselect * from tablename。653.654.655. 86. 如何查詢數(shù)據(jù)庫有多少表?656.657. SQLselect * from all_ta