资源描述:
《Oracle练习用表(DEPT、EMP、BONUS、SALGRADE)的建表语句.doc》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、----------Oracle自带的练习用表的建表语句文件:C:OracleOracle11g11.2.0dbhome_1RDBMSADMINutlsampl.sql----------RemCopyright(c)1990,2006,Oracle.Allrightsreserved.RemNAMEREMUTLSAMPL.SQLRemFUNCTIONRemNOTESRemMODIFIEDRemlburgess04/02/06-lowercasepasswordsRemmenash02/21/01-removeunnecessaryusersforsecurityr
2、easonsRemgwood03/23/99-makealldatesY2KcompliantRemjbellemo02/27/97-dontconnectassystemRemakolk08/06/96-bug:AddingdateformatsRemglumpkin10/21/92-RenamedfromSQLBLD.SQLRemblinden07/27/92-AddedprimaryandforeignkeystoEMPandDEPTRemrlim04/29/91-changechartovarchar2Remmmoore04/08/91-useunlimitedtable
3、spaceprivRempritto04/04/91-changeSYSDATEto13-JUL-87RemMendels12/07/90-bug30123;addto_datecallssolanguageindependentRemremrem$Header:utlsampl.sql02-apr-2006.21:13:01lburgessExp$sqlbld.sqlremSETTERMOUTOFFSETECHOOFFremCONGDONInvokedinRDBMSatbuildtime.29-DEC-1988remOATES:Created:16-Feb-83DROPUSER
4、SCOTTCASCADE;DROPUSERADAMSCASCADE;DROPUSERJONESCASCADE;DROPUSERCLARKCASCADE;DROPUSERBLAKECASCADE;GRANTCONNECT,RESOURCE,UNLIMITEDTABLESPACETOSCOTTIDENTIFIEDBYtiger;DROPPUBLICSYNONYMPARTS;CONNECTSCOTT/tigerCREATETABLEDEPT(DEPTNONUMBER(2)CONSTRAINTPK_DEPTPRIMARYKEY,DNAMEVARCHAR2(14),LOCVARCHAR2(
5、13));INSERTINTODEPTVALUES(10,'ACCOUNTING','NEWYORK');INSERTINTODEPTVALUES(20,'RESEARCH','DALLAS');INSERTINTODEPTVALUES(30,'SALES','CHICAGO');INSERTINTODEPTVALUES(40,'OPERATIONS','BOSTON');CREATETABLEEMP(EMPNONUMBER(4)CONSTRAINTPK_EMPPRIMARYKEY,ENAMEVARCHAR2(10),JOBVARCHAR2(9),MGRNUMBER(4),HIR
6、EDATEDATE,SALNUMBER(7,2),COMMNUMBER(7,2),DEPTNONUMBER(2)CONSTRAINTFK_DEPTNOREFERENCESDEPT);INSERTINTOEMPVALUES(7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);INSERTINTOEMPVALUES(7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30);INSERTINTOEM
7、PVALUES(7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);INSERTINTOEMPVALUES(7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);INSERTINTOEMPVALUES(7654,'MARTIN','SALESMAN',7698,to_date('28-9-