资源描述:
《oracledatabase10g基础教程(第二版)ppt和示例代码--代码部分》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、createtableemp_history(empnointeger,total_payinteger,update_datedate);insertintoemp一historyvalues(1,100,*08-60A-2006*);insertintoemp_historyvalues(2,200,*15-60A-20061;createtableemp_history_adds(empnointeger,net_payinteger);insertintoemp_history_addsvalues(1,150);insertintoemp_
2、history_addsvalues(3,300);select*fromemp_history;select*fromemp_history_adds;mergeintoemp—historyehusingemp_history_addsehaon(eh.empno=eha.empno)whenmatchedthenupdateseteh.total—pay=eha.net_payAeh.update_date=108-80A-20081;createtablenames(namevarchar2(30));insertintonamesvalue
3、s(q1[Johnsons1sbookisverygood.]1);select*fromnameswherename=q1XJohnsons1sbookisverygood.X1;createtablespacemydbtbsdatafile’/oralOO/oracle/niydb/myclb_tbs_01.dbf’size100m;createrollbacksegmenttbs_rs01tablespacemydb_tbsstorage(initial100knext100kminextents10optimal1000k);createta
4、blespacemytbsdatafile’oral00/oracle/mydb/mydb_tbs_001.dbf’size100m;alterdatabaseaddlogfilegroup4(,c:oracleoradatamydbmydblogfilegroup41a.log’,’d:oracleoradatainydbiydb_logfile_group4_l_b.log’)size100m;columnenameheading’雇员姓名,formatA15columnsalheading’薪水’justifycenterfo
5、rmat$99,999.00columncommheading’红利’justifyrightformat$99,999.00NULL’无’columnhiredateheading’聘用日期’selectename,sal,comm,hiredatefromemp;ttitle’雇员薪水清革’btitleTom科技发展有限公tfjselectempno,ename,salfromenip;selectempno,ename,sal,jobfromemp;setpagesize20selectempno,ename,sal,jobfromemp;sh
6、ow1inesizeselect*fromcmp;setlinesize160select氺fromemp;showfeedbackselect氺fromenip;select*fromempwhererownum<6;createtable11(colNamenumber);insertinsertinsertintotlvalues(1234567890);intotlvalues(12345678901);intotlvalues(12345678901234567890);select本fromt1;setnumformat999999999
7、9999999999999999999999.999999999999999selecttextfromall_vicwswhereviewname=’USERTABLES’;MMMBsetpagesize1000setlong10000/describeempdosedeptdescdbms_outputselectename,sal,job,hiredatefromempwheresal>&amount;selectempno,ename,&columnName,jobfrom&tableNamewhere^conditionorderby&or
8、dcrCo1uninName;selectenipno,ename,job,&columnNamefrome