神州數(shù)碼ORACLE SQL講義課件

SQL課程大綱如何進(jìn)入Sqlplus建立/修改TableINSERT指令介紹UPDATE指令介紹DELETE指令介紹SELECT指令介紹WHERE

Function

介紹GroupFunction介紹OracleFunction

介紹LOAD,UNLOAD指令介紹Sqlplus內(nèi)的一些命令介紹SQL課程大綱如何進(jìn)入Sqlplus進(jìn)入ISQLsqlplus

1.常規(guī)登陸sqlplusSQL*Plus:Release9.2.0.1.0-Productionon星期三9月1709:57:022003Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.2.快捷登陸sqlplususername/passwdusername登陸用戶名passwd登陸用戶密碼

SQL*Plus:Release9.2.0.1.0-Productionon星期三9月1709:59:182003Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.1.0-ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0-Production進(jìn)入ISQLsqlplus建立/修改Table數(shù)據(jù)類型:

VARCHAR2(size)字符類型(變長)例VARCHAR2(10)CHAR[(size)]字符類型(定長)例CHAR(10)NUMBER[(p,s)]數(shù)值類型例:NUMBER(5)表示5位整數(shù)例:NUMBER(15,3)表11位整數(shù),3位小數(shù)

DATE日期時間類型LONG變長字符類型,最大長度2GCLOB字符類型，最大長度4GBLOB二進(jìn)制類型，最大長度4GROWID16進(jìn)制字符串，代表在表中的一個行的唯一地址建立/修改Table數(shù)據(jù)類型:VARCHAR2(size)字建立/更改Table1.寫好createtable的sql再執(zhí)行

vidpe_file.sch/*=========================================================檔案代號:dpe_file檔案名稱:體檢項目代號資料檔==========.===================.===========================*/createtabledpe_file(dpe01varchar2(6),/*體檢項目代號*/dpe02varchar2(30),/*說明*/dpe03varchar2(01),/*Nouse*/dpeactivarchar2(01),/*資料有效碼*/dpeuservarchar2(10),/*資料所有者*/dpegrupvarchar2(06),/*資料所有部門*/dpemoduvarchar2(10),/*資料修改者*/dpedatedate/*最近修改日*/);createuniqueindexdpe_01ondpe_file(dpe01);

建立/更改Table1.寫好createtable的sq建立/更改Table2.在unix環(huán)境下sqlplusds/ds<dpe_file.sch即可createtable了

</u1/topo/apy/sql>sqlplusds/ds<dpe_file.schSQL*Plus:Release9.2.0.1.0-Productionon星期三9月1710:37:232003Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.1.0-ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0-ProductionDOC>============================================================DOC>檔案代號:dpe_fileDOC>檔案名稱:體檢項目代號資料檔DOC>==========.===================.==============================DOC>*/Tablecreated.Indexcreated.SQL>建立/更改Table2.在unix環(huán)境下sqlplus建立/更改Table3.在sqlplus環(huán)境下建立table

SQL>createtabledpe_file2(3dpe01varchar2(6),/*體檢項目代號*/4dpe02varchar2(30),/*說明*/5dpe03varchar2(01),/*Nouse*/6dpeactivarchar2(01),/*資料有效碼*/7dpeuservarchar2(10),/*資料所有者*/8dpegrupvarchar2(06),/*資料所有部門*/9dpemoduvarchar2(10),/*資料修改者*/10dpedatedate/*最近修改日*/11);Tablecreated.SQL>createuniqueindexdpe_01ondpe_file(dpe01);Indexcreated.SQL>建立/更改Table3.在sqlplus環(huán)境下建立tab建立/更改TableSQL>descdpe_file;NameNull?Type-----------------------------------------------------------------------------DPE01VARCHAR2(6)DPE02VARCHAR2(30)DPE03VARCHAR2(1)DPEACTIVARCHAR2(1)DPEUSERVARCHAR2(10)DPEGRUPVARCHAR2(6)DPEMODUVARCHAR2(10)DPEDATEDATE

SQL>建立/更改TableSQL>descdpe_file;建立/修改Table修改table

1.寫成sql更改

SQL>edalter_dpe.sch

altertabledpe_filemodify(dpe01varchar2(10));/*修改dpe01*/

altertabledpe_fileadd(dpe00varchar2(10));

/*增加dep00*/altertabledpe_filedrop(dpe03);/*刪除dpe03*/dropindexdpe_01;/*刪除索引*/SQL>@alter_dpe.schTablealtered.Tablealtered.Tablealtered.Indexdropped.

建立/修改Table修改table建立/修改Table2.進(jìn)入sqlplus更改

SQL>altertabledpe_filemodify(dpe01varchar2(10));Tablealtered.SQL>altertabledpe_fileadd(dpe00varchar2(10));Tablealtered.SQL>altertabledpe_filedrop(dpe03);Tablealtered.SQL>dropindexdpe_01;Indexdropped.SQL>建立/修改Table2.進(jìn)入sqlplus更改建立/修改TableSQL>descdpe_file;NameNull?Type-----------------------------------------------------------------------------DPE01VARCHAR2(10)DPE02VARCHAR2(30)DPEACTIVARCHAR2(1)DPEUSERVARCHAR2(10)DPEGRUPVARCHAR2(6)DPEMODUVARCHAR2(10)DPEDATEDATEDPE00VARCHAR2(10)

建立/修改TableSQL>descdpe_file;INSERT指令介紹INSERTINTOtable_name[(column-list)]VALUES(value-list)范例:1.INSERTINTOdpe_fileVALUES('A00003','test','','Y','carrier','1400','','03/09/17‘)2.INSERTINTOcus_file(cus01,cus02)

VALUES(‘C00002’,‘test01’);INSERT指令介紹INSERTINTOtable_nUPDATE指令介紹Syntax

UPDATEtable_nameSETcol=expr,col=expr[WHEREclause]

范列說明:

1.UPDATEdpe_fileSETdpe02=‘test02’WHEREdpe01LIKE‘A%1’2.UPDATEdpe_fileSETdpe02='test02',dpeacti='N‘WHEREdpe01like'A%1'

3.UPDATEdpe_fileSETdpeuser='michael‘,dpegrup='2100‘WHERE(dpe01='A00002'ordpe01like'C_000_');UPDATE指令介紹SyntaxDELETE指令介紹Syntax:

DELETEFROMtable_name[WHEREclause]范例說明:

1.DELETEFROMdpe_file

[注意]:沒有where條件會將所有資料刪除且無法將資料還原2.DELETEFROMdpe_fileWHEREdpe01LIKE‘C%’DELETE指令介紹Syntax:SELECT指令介紹Syntax:SELECTcolumn,group_function(column)FROMtable_name[WHEREcondition][GROUPBYgroup_by_expression][HAVINGgroup_condition][ORDERBYcolumn]

范例說明:1.SELECT*FROMcus_fileorderbycus01ASC2.SELECTcus01,cus02FROMcus_fileorderbycus01DESC,cus023.SELECTlast_name,salary,12*salary+100FROMemployee4.SELECTlast_nameAsname,commissioncommFROMemployee5.SELECTlast_name||job_idas“EmployeeInfo”FROMemployee6.SELECTlast_name||‘isa’||job_idas“EmployeeDetail”FROMemployee7.SELECTdistinctdpe02FROMdpe_file8.SELECTlast_name,ageFROMemployeeWHEREage<=45

SELECT指令介紹Syntax:SELECT指令介紹范例說明:

9.SELECT*FROMemployeeWHEREagebetween20and65SELECT*FROMdpe_fileWHEREdpe02isnulland(dpeacti=‘Y’ordpeuserlike‘carr%’)10.SELECTemployee_id,UPPER(last_name)FROMemployeeWHEREINITCAP(last_name)=‘Higgins’SELECTemployee_id,CONCAT(first_name,last_name)NAME,job_id,LENGTH(last_name),INSTR(last-name,’a’)“Contain‘a(chǎn)’?”

FROMemployeeWHERESUBSTR(job_id,4)=“REP”SELECTlast_name,salary,MOD(salary,5000)FROMemployeeWHEREjob_id=‘SA_REP’

Jointable範(fàn)例:11.SELECToea01,oeb02,oeb04,oeb12FROMoea_file,oeb_fileWHEREoea01=oeb0112.SELECTe.employee_id,e.last_name,e.department_id,d.department_id,d.location_idFROMemployeee,departmentdWHEREe.department_id=d.department_id

SELECT指令介紹范例說明:SELECT指令介紹范例說明:

13.SELECTe.last_name,e.department_id,d.department_nameFROMemployeee,departmentdWHEREe.department_id(+)=d.department_id

SELECTe.last_name,e.department_id,d.department_nameFROMemployeee,departmentdWHEREe.department_id=d.department_id(+)14.INSERTINTOcus1_fileSELECT*FROMcus_file15.INSERTINTOcua_file(cua01,cua02)

SELECTcus01,cus02FROMcus_fileWHEREcus01MATCHES‘C*’16.SELECTCOUNT(*)FROMoea_fileWHEREoea02BETWEEN’01/01/01’AND’01/12/31’

17.SELECTCOUNT(DISTINCToea03)FROMoea_fileWHEREoea02BETWEEN’01/01/01’AND’01/12/31’

18.SELECTMAX(oea02),MIN(oea02)FROMoea_fileWHEREoea02BETWEEN’01/01/01’AND’01/12/31’SELECT指令介紹范例說明:SELECT指令介紹范例說明:

19.SELECTAVG(oeb12)FROMoea_file,oeb_fileWHEREoea02BETWEEN'010101'AND'011231'ANDoea01=oeb01ANDoeb04='11-03-SDD16‘a(chǎn)ndoeb12<>0

20.SELECT*FROMoea_fileWHEREoea02=(SELECTMAX(oea02)FROMoea_fileWHEREoea02>=’01/01/01’)

21.SELECTdepartment_id,AVG(salary)FROMemployeeGROUPBYdepartment_id22.SELECTdepartment_id,MAX(salary)FROMemployeeGROUPBYdepartment_id

HAVINGMAX(salary)>10000

SELECT指令介紹范例說明:SELECT指令介紹----where比較符號

‘=’‘>’‘>=’‘<’‘<=’‘<>’其它比較符號BETWEEN..AND..WHEREagebetween20and30IN(..)WHEREagein(20,21,22,23,24,25,26,27,28,29,30)LIKEWHEREdpe01like‘A_0%’ISNULLWHEREageisnullSELECT指令介紹----where比較符號SELECT指令介紹----where邏輯符號

‘AND’‘OR’‘NOT’

wheredpe01=‘A00001’ANDdpe02=‘test01’wheredpe01=‘A00001’ORdpe01=‘C00001’whereagenotin(20,21,22,23,24,25,26,27,28,29,30)SELECT指令介紹----where邏輯符號GroupFunctionAVGCOUNTMAXMINSTDDEVSUMGroupFunctionAVGOracleFunction---1Case-manipulationfunctionslower,upper,initcapCharacter-manipulationfunctionsconcat,substr,length,instr,lpad,rpad,trimFunctionResultLOWER(‘SQLCourse’)sqlcourseUPPER(‘SQLCourse’)SQLCOURSEINITCAP(‘SQLCourse’)SqlCourseCONCAT(‘Hello’,’World’)HelloWorldSUBSTR(‘Helloworld’,1,5)HelloLENGTH(‘HelloWorld’)10INSTR(‘HelloWorld’,W)6LPAD(salary,10,’*’)*****24000RPAD(salary,10,’*’)24000*****TRIM(‘H’FROM‘HelloWorld)elloWorldOracleFunction---1Case-manipuFUNCTION---2NumberFunctionROUNDround(45.926,2)45.93TRUNCtrunc(45.926,2)45.92MODmod(1600,300)100FUNCTION---2NumberFunctionLOAD/UNLOAD指令介紹因為oracle沒有提供類似INFORMIX的load,unload語句，所以在tiptop環(huán)境下有一些工具1.使用loadshell,loadshell會去呼叫$TOP/ora/load.42m程序使用方式Usage:loaddatabasetablenametxtfileEx:loaddsze_fileze_file.txt2.使用loaddbshell,loaddbshell會去呼叫externaltoolsSQL*Loader使用方式Usage:/u1/topo/ora/bin/loaddbdbname[tablename][txtfile]Ex1:/u1/topo/ora/bin/loaddbds1Ex2:/u1/topo/ora/bin/loaddbds1ima_file[ima_file.txt]Ex3:/u1/topo/ora/bin/loaddbds1i%_file3.直接使用Oracle提供的SQL*Loader,但必須自己編輯controlfile,用法sqlldrds/dscontrol=azb_file.ctllog=azb_file.logLOAD/UNLOAD指令介紹因為oracle沒有提供類似ILOAD/UNLOAD指令介紹controlfile格式如下loaddatainfile'/u1/tiptopo/azb_file.txt'appendintotableazb_filefieldsterminatedby'^A'(azb01,azb02,azb06,azbacti,azbuser,azbgrup,azbmodu,azbdate)4.另外可以在BDL程序中使用channel的方式來產(chǎn)生SQL*Loader所需用的controlfile,再透過RUNcommand的作法來激活SQL*Loader,channel的寫法可參考BDL文件LOAD/UNLOAD指令介紹Sqlplus一些命令介紹Helpindex查詢相關(guān)命令@運行.sql的文件Ed類似于viGet將一句sql語句放入sql緩沖器R–run/重復(fù)上一個在memory中的commandDesc顯示表結(jié)構(gòu)Spool記錄執(zhí)行過程Startget+rSave將memory中的命令保存在一個文件中Set設(shè)置一些oracle設(shè)定Sqlplus一些命令介紹Helpindex查詢相關(guān)Sqlplus一些命令介紹示范helpaccept找尋accept的幫助信息@c_dpe.sql執(zhí)行c_dpe.sql中的內(nèi)容edc_dpe.sql編輯一個文件c_dpe.sqlgetc_dpe.sql將該文件的內(nèi)容放入memoery中r執(zhí)行memory中的命令/同rdescdpe_file查看dpe_file的表結(jié)構(gòu)spoolfile.lst將在這期間執(zhí)行的命令及結(jié)果放入file.lst文件sqlplus命令

spooloffStartc_dpe.sql執(zhí)行start后面文件中的內(nèi)容savet1.sqlsetwrapon設(shè)置可以折行顯示SetheadingoffSqlplus一些命令介紹示范新增表格先寫sql然後進(jìn)入路徑下sqlplusavydg/avydg@表名更新sechma進(jìn)入路徑sqlplusds/ds@表名查詢索引@q_index新增表格先寫sqlSQL課程大綱如何進(jìn)入Sqlplus建立/修改TableINSERT指令介紹UPDATE指令介紹DELETE指令介紹SELECT指令介紹WHERE

Function

介紹GroupFunction介紹OracleFunction

介紹LOAD,UNLOAD指令介紹Sqlplus內(nèi)的一些命令介紹SQL課程大綱如何進(jìn)入Sqlplus進(jìn)入ISQLsqlplus

1.常規(guī)登陸sqlplusSQL*Plus:Release9.2.0.1.0-Productionon星期三9月1709:57:022003Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.2.快捷登陸sqlplususername/passwdusername登陸用戶名passwd登陸用戶密碼

SQL*Plus:Release9.2.0.1.0-Productionon星期三9月1709:59:182003Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.1.0-ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0-Production進(jìn)入ISQLsqlplus建立/修改Table數(shù)據(jù)類型:

VARCHAR2(size)字符類型(變長)例VARCHAR2(10)CHAR[(size)]字符類型(定長)例CHAR(10)NUMBER[(p,s)]數(shù)值類型例:NUMBER(5)表示5位整數(shù)例:NUMBER(15,3)表11位整數(shù),3位小數(shù)

DATE日期時間類型LONG變長字符類型,最大長度2GCLOB字符類型，最大長度4GBLOB二進(jìn)制類型，最大長度4GROWID16進(jìn)制字符串，代表在表中的一個行的唯一地址建立/修改Table數(shù)據(jù)類型:VARCHAR2(size)字建立/更改Table1.寫好createtable的sql再執(zhí)行

vidpe_file.sch/*=========================================================檔案代號:dpe_file檔案名稱:體檢項目代號資料檔==========.===================.===========================*/createtabledpe_file(dpe01varchar2(6),/*體檢項目代號*/dpe02varchar2(30),/*說明*/dpe03varchar2(01),/*Nouse*/dpeactivarchar2(01),/*資料有效碼*/dpeuservarchar2(10),/*資料所有者*/dpegrupvarchar2(06),/*資料所有部門*/dpemoduvarchar2(10),/*資料修改者*/dpedatedate/*最近修改日*/);createuniqueindexdpe_01ondpe_file(dpe01);

建立/更改Table1.寫好createtable的sq建立/更改Table2.在unix環(huán)境下sqlplusds/ds<dpe_file.sch即可createtable了

</u1/topo/apy/sql>sqlplusds/ds<dpe_file.schSQL*Plus:Release9.2.0.1.0-Productionon星期三9月1710:37:232003Copyright(c)1982,2002,OracleCorporation.Allrightsreserved.Connectedto:Oracle9iEnterpriseEditionRelease9.2.0.1.0-ProductionWiththePartitioning,OLAPandOracleDataMiningoptionsJServerRelease9.2.0.1.0-ProductionDOC>============================================================DOC>檔案代號:dpe_fileDOC>檔案名稱:體檢項目代號資料檔DOC>==========.===================.==============================DOC>*/Tablecreated.Indexcreated.SQL>建立/更改Table2.在unix環(huán)境下sqlplus建立/更改Table3.在sqlplus環(huán)境下建立table

SQL>createtabledpe_file2(3dpe01varchar2(6),/*體檢項目代號*/4dpe02varchar2(30),/*說明*/5dpe03varchar2(01),/*Nouse*/6dpeactivarchar2(01),/*資料有效碼*/7dpeuservarchar2(10),/*資料所有者*/8dpegrupvarchar2(06),/*資料所有部門*/9dpemoduvarchar2(10),/*資料修改者*/10dpedatedate/*最近修改日*/11);Tablecreated.SQL>createuniqueindexdpe_01ondpe_file(dpe01);Indexcreated.SQL>建立/更改Table3.在sqlplus環(huán)境下建立tab建立/更改TableSQL>descdpe_file;NameNull?Type-----------------------------------------------------------------------------DPE01VARCHAR2(6)DPE02VARCHAR2(30)DPE03VARCHAR2(1)DPEACTIVARCHAR2(1)DPEUSERVARCHAR2(10)DPEGRUPVARCHAR2(6)DPEMODUVARCHAR2(10)DPEDATEDATE

SQL>建立/更改TableSQL>descdpe_file;建立/修改Table修改table

1.寫成sql更改

SQL>edalter_dpe.sch

altertabledpe_filemodify(dpe01varchar2(10));/*修改dpe01*/

altertabledpe_fileadd(dpe00varchar2(10));

/*增加dep00*/altertabledpe_filedrop(dpe03);/*刪除dpe03*/dropindexdpe_01;/*刪除索引*/SQL>@alter_dpe.schTablealtered.Tablealtered.Tablealtered.Indexdropped.

建立/修改Table修改table建立/修改Table2.進(jìn)入sqlplus更改

SQL>altertabledpe_filemodify(dpe01varchar2(10));Tablealtered.SQL>altertabledpe_fileadd(dpe00varchar2(10));Tablealtered.SQL>altertabledpe_filedrop(dpe03);Tablealtered.SQL>dropindexdpe_01;Indexdropped.SQL>建立/修改Table2.進(jìn)入sqlplus更改建立/修改TableSQL>descdpe_file;NameNull?Type-----------------------------------------------------------------------------DPE01VARCHAR2(10)DPE02VARCHAR2(30)DPEACTIVARCHAR2(1)DPEUSERVARCHAR2(10)DPEGRUPVARCHAR2(6)DPEMODUVARCHAR2(10)DPEDATEDATEDPE00VARCHAR2(10)

建立/修改TableSQL>descdpe_file;INSERT指令介紹INSERTINTOtable_name[(column-list)]VALUES(value-list)范例:1.INSERTINTOdpe_fileVALUES('A00003','test','','Y','carrier','1400','','03/09/17‘)2.INSERTINTOcus_file(cus01,cus02)

VALUES(‘C00002’,‘test01’);INSERT指令介紹INSERTINTOtable_nUPDATE指令介紹Syntax

UPDATEtable_nameSETcol=expr,col=expr[WHEREclause]

范列說明:

1.UPDATEdpe_fileSETdpe02=‘test02’WHEREdpe01LIKE‘A%1’2.UPDATEdpe_fileSETdpe02='test02',dpeacti='N‘WHEREdpe01like'A%1'

3.UPDATEdpe_fileSETdpeuser='michael‘,dpegrup='2100‘WHERE(dpe01='A00002'ordpe01like'C_000_');UPDATE指令介紹SyntaxDELETE指令介紹Syntax:

DELETEFROMtable_name[WHEREclause]范例說明:

1.DELETEFROMdpe_file

[注意]:沒有where條件會將所有資料刪除且無法將資料還原2.DELETEFROMdpe_fileWHEREdpe01LIKE‘C%’DELETE指令介紹Syntax:SELECT指令介紹Syntax:SELECTcolumn,group_function(column)FROMtable_name[WHEREcondition][GROUPBYgroup_by_expression][HAVINGgroup_condition][ORDERBYcolumn]

范例說明:1.SELECT*FROMcus_fileorderbycus01ASC2.SELECTcus01,cus02FROMcus_fileorderbycus01DESC,cus023.SELECTlast_name,salary,12*salary+100FROMemployee4.SELECTlast_nameAsname,commissioncommFROMemployee5.SELECTlast_name||job_idas“EmployeeInfo”FROMemployee6.SELECTlast_name||‘isa’||job_idas“EmployeeDetail”FROMemployee7.SELECTdistinctdpe02FROMdpe_file8.SELECTlast_name,ageFROMemployeeWHEREage<=45

SELECT指令介紹Syntax:SELECT指令介紹范例說明:

9.SELECT*FROMemployeeWHEREagebetween20and65SELECT*FROMdpe_fileWHEREdpe02isnulland(dpeacti=‘Y’ordpeuserlike‘carr%’)10.SELECTemployee_id,UPPER(last_name)FROMemployeeWHEREINITCAP(last_name)=‘Higgins’SELECTemployee_id,CONCAT(first_name,last_name)NAME,job_id,LENGTH(last_name),INSTR(last-name,’a’)“Contain‘a(chǎn)’?”

FROMemployeeWHERESUBSTR(job_id,4)=“REP”SELECTlast_name,salary,MOD(salary,5000)FROMemployeeWHEREjob_id=‘SA_REP’

Jointable範(fàn)例:11.SELECToea01,oeb02,oeb04,oeb12FROMoea_file,oeb_fileWHEREoea01=oeb0112.SELECTe.employee_id,e.last_name,e.department_id,d.department_id,d.location_idFROMemployeee,departmentdWHEREe.department_id=d.department_id

SELECT指令介紹范例說明:SELECT指令介紹范例說明:

13.SELECTe.last_name,e.department_id,d.department_nameFROMemployeee,departmentdWHEREe.department_id(+)=d.department_id

SELECTe.last_name,e.department_id,d.department_nameFROMemployeee,departmentdWHEREe.department_id=d.department_id(+)14.INSERTINTOcus1_fileSELECT*FROMcus_file15.INSERTINTOcua_file(cua01,cua02)

SELECTcus01,cus02FROMcus_fileWHEREcus01MATCHES‘C*’16.SELECTCOUNT(*)FROMoea_fileWHEREoea02BETWEEN’01/01/01’AND’01/12/31’

17.SELECTCOUNT(DISTINCToea03)FROMoea_fileWHEREoea02BETWEEN’01/01/01’AND’01/12/31’

18.SELECTMAX(oea02),MIN(oea02)FROMoea_fileWHEREoea02BETWEEN’01/01/01’AND’01/12/31’SELECT指令介紹范例說明:SELECT指令介紹范例說明:

19.SELECTAVG(oeb12)FROMoea_file,oeb_fileWHEREoea02BETWEEN'010101'AND'011231'ANDoea01=oeb01ANDoeb04='