資源描述:
《oracle創(chuàng)建表的過程》由會員上傳分享,免費(fèi)在線閱讀,更多相關(guān)內(nèi)容在應(yīng)用文檔-天天文庫。
1、1.遠(yuǎn)程:training2.1234563.orcl34.本地:sys5.tiger6.sysdba7.8.9.10.以管理員的形式創(chuàng)建一個普通用戶表,用戶名是sys,密碼是tiger;11.右鍵點(diǎn)擊創(chuàng)建一個表12.13.新建一個sql的窗口1.grantcreatetabletotransformer;grantcreateviewtotransformer;grantcreatesequencetotransformer;//防止登錄失敗grantcreatesessiontotransformer;//給用戶表空間進(jìn)行授權(quán)alterusertransformerquotaunlim
2、itedonusers;2.登錄3.createtablephoto_albums(albumidnumber(10)notnullprimarykey,albumnamevarchar2(100)notnull,descriptionvarchar2(600),builddatedatenotnull)createtablephoto_photos(photoidnumber(10)notnullprimarykey,photonamevarchar2(100)notnull,albumidnumber(10)notnull,screendatedatenotnull,descripti
3、onvarchar2(600),phototypevarchar2(100)notnull,foreignkey(photoid)referencesphoto_albums(albumid))createtabletraining_users(useridnumber(10)notnullprimarykey,usernamevarchar2(50)notnull,passwordvarchar2(100)notnull,realnamevarchar2(50))4.5.右鍵-編輯-1.講photoid的值改成albumid;2.創(chuàng)建序列3.createsequenceseq_photo
4、_albumsincrementby1startwith1nomaxvaluenominvaluenocachecreatesequenceseq_photo_photosincrementby1startwith1nomaxvaluenominvaluenocache1.insertintotraining_usersvalues(1,'admin','11','zt');2.insertintophoto_albums(albumid,albumname,description,builddate)values(seq_photo_albums.nextval,'moon2','898
5、9757336',sysdate);3.insertintophoto_photosvalues(seq_photo_photos.nextval,'moon',1,sysdate,'1111111','image/gif');4.select*fromphoto_albums;select*fromphoto_photos;數(shù)據(jù)庫的配置信息