oracle登陆时的系统/ SYS用户的密码忘了怎么办
在服务器本地登录,不用打密码
sqlplus / as sysdba
登录之后再改密码
alter user sys identified by oracle;
alter user system identified by oracle;
修改oracle确定的用户系统;
1首先在开始菜单中打开sql developer;
1.1)第一次打开需要输入SQL Developer在浏览把路径导入我的是E:\ app \ Administrator \ product \ 11.2.0 \ dbhome_1 \ jdk \ bin \ java.exe稍等一会就会打开SQL Developer会提示是否从以前版本移植选择否就可以了
2.创建数据库连接
点击左上角的加号
在弹出的对话框中填写用户名和密码
测试如果成功则点击连接,记得角色要写SYSDBA
连接名:随意写
如果是普通用户比如张三密码张三
连接类型:基本角色:默认
SID:我的是ORCL
教你查看自己本机上的SID
打开cmd输入sqlplus / nolog
SQL> conn / as sysdba;
SQL> select instance_name from V$instance;
3.运行脚本
之后把SQL必知必会的脚本拷到工作表中并点击运行脚本
首先进行表的创建
输入代码:
- ---------------------------------------------
- - Sams在10分钟内自学SQL
- - http://www.forta.com/books/0672325675/
- - Oracle示例表创建脚本。
- ---------------------------------------------
- -------------------------
- - 创建客户表
- -------------------------
- CREATE TABLE 客户
- (
- cust_id char (10) NOT NULL ,
- cust_name char (50) NOT NULL ,
- cust_address char (50) NULL ,
- cust_city char (50) NULL ,
- cust_state char (5) NULL ,
- cust_zip char (10) NULL ,
- cust_country char (50) NULL ,
- cust_contact char (50) NULL ,
- cust_email char (255) NULL
- );
- --------------------------
- - 创建OrderItems表
- --------------------------
- CREATE TABLE OrderItems
- (
- order_num int NOT NULL ,
- order_item int NOT NULL ,
- prod_id char (10) NOT NULL ,
- 数量 int NOT NULL ,
- item_price decimal (8,2) NOT NULL
- );
- ----------------------
- - 创建订单表
- ----------------------
- CREATE TABLE 订单
- (
- order_num int NOT NULL ,
- order_date date NOT NULL ,
- cust_id char (10) NOT NULL
- );
- ------------------------
- - 创建产品表
- ------------------------
- CREATE TABLE 产品
- (
- prod_id char (10) NOT NULL ,
- vend_id char (10) NOT NULL ,
- prod_name char (255) NOT NULL ,
- prod_price decimal (8,2) NOT NULL ,
- prod_desc varchar (1000) NULL
- );
- -----------------------
- - 创建供应商表
- -----------------------
- CREATE TABLE 供应商
- (
- vend_id char (10) NOT NULL ,
- vend_name char (50) NOT NULL ,
- vend_address char (50) NULL ,
- vend_city char (50) NULL ,
- vend_state char (5) NULL ,
- vend_zip char (10) NULL ,
- vend_country char (50) NULL
- );
- ----------------------
- - 定义主键
- ----------------------
- ALTER TABLE 客户 添加CONSTRAINT PK_Customers PRIMARY KEY (cust_id);
- ALTER TABLE OrderItems ADD CONSTRAINT PK_OrderItems PRIMARY KEY (order_num,order_item);
- ALTER TABLE 命令 ADD CONSTRAINT PK_Orders PRIMARY KEY (order_num);
- ALTER TABLE 产品 ADD CONSTRAINT PK_Products PRIMARY KEY (prod_id);
- ALTER TABLE 供应商 添加CONSTRAINT PK_Vendors PRIMARY KEY (vend_id);
- ----------------------
- - 定义外键
- ----------------------
- ALTER TABLE OrderItems
- ADD CONSTRAINT FK_OrderItems_Orders FOREIGN KEY (order_num) REFERENCES Orders(order_num);
- ALTER TABLE OrderItems
- ADD CONSTRAINT FK_OrderItems_Products FOREIGN KEY (prod_id) REFERENCES Products(prod_id);
- ALTER TABLE 订单
- 添加约束 FK_Orders_Customers FOREIGN KEY (cust_id) 参考 客户(cust_id);
- ALTER TABLE 产品
- ADD CONSTRAINT FK_Products_Vendors FOREIGN KEY (vend_id) REFERENCES 供应商(vend_id);
运行脚本后输出:表建立完成
之后给表添加元素:
加入脚本:
- -----------------------------------------------
- - Sams在10分钟内自学SQL
- - http://www.forta.com/books/0672325675/
- - Oracle示例表格填充脚本。
- -----------------------------------------------
- ---------------------------
- - 填充客户表
- ---------------------------
- INSERT INTO 客户(CUST_ID,CUST_NAME,cust_address,cust_city,cust_state,cust_zip,cust_country,cust_contact,CUST_EMAIL)
- VALUES ('1000000001' , 'Village Toys' , '200 Maple Lane' , '底特律' , 'MI' , '44444' , '美国' , '约翰史密斯' , 'sales@villagetoys.com' );
- INSERT INTO 客户(CUST_ID,CUST_NAME,cust_address,cust_city,cust_state,cust_zip,cust_country,cust_contact)
- VALUES ('1000000002' , 'Kids Place' , '333 South Lake Drive' , 'Columbus' , 'OH' , '43333' , 'USA' , 'Michelle Green' );
- INSERT INTO 客户(CUST_ID,CUST_NAME,cust_address,cust_city,cust_state,cust_zip,cust_country,cust_contact,CUST_EMAIL)
- VALUES ('1000000003' , 'Fun4All' , '1 Sunny Place' , 'Muncie' , 'IN' , '42222' , 'USA' , 'Jim Jones' , 'jjones@fun4all.com' );
- INSERT INTO 客户(CUST_ID,CUST_NAME,cust_address,cust_city,cust_state,cust_zip,cust_country,cust_contact,CUST_EMAIL)
- VALUES ('1000000004' , 'Fun4All' , '829 Riverside Drive' , 'Phoenix' , 'AZ' , '88888' , 'USA' , 'Denise L. Stephens' , 'dstephens@fun4all.com' );
- INSERT INTO 客户(CUST_ID,CUST_NAME,cust_address,cust_city,cust_state,cust_zip,cust_country,cust_contact)
- VALUES ('1000000005' , '玩具商店' , '4545第53街' , '芝加哥' , 'IL' , '54545' , '美国' , '金霍华德' );
- -------------------------
- - 填充供应商表
- -------------------------
- INSERT INTO 供应商(vend_id,vend_name,vend_address,vend_city,vend_state,vend_zip,vend_country)
- VALUES ('BRS01' ,'Bears R Us' ,'123 Main Street' ,'Bear Town' ,'MI' ,'44444' , 'USA' );
- INSERT INTO 供应商(vend_id,vend_name,vend_address,vend_city,vend_state,vend_zip,vend_country)
- VALUES ('BRE02' ,'Bear Emporium' ,'500 Park Street' ,'Anytown' ,'OH' ,'44333' , 'USA' );
- INSERT INTO 供应商(vend_id,vend_name,vend_address,vend_city,vend_state,vend_zip,vend_country)
- VALUES ('DLL01' ,'Doll House Inc.' ,'555 High Street' ,'Dollsville' ,'CA' ,'99999' , 'USA' );
- INSERT INTO 供应商(vend_id,vend_name,vend_address,vend_city,vend_state,vend_zip,vend_country)
- VALUES ('FRB01' ,'Furball Inc.' ,'1000 5th Avenue' ,'New York' ,'NY' ,'11111' , 'USA' );
- INSERT INTO 供应商(vend_id,vend_name,vend_address,vend_city,vend_state,vend_zip,vend_country)
- VALUES ('FNG01' ,'娱乐和游戏' ,'42 Galaxy路' ,'伦敦' , NULL ,'N16 6PS' , '英格兰' );
- INSERT INTO 供应商(vend_id,vend_name,vend_address,vend_city,vend_state,vend_zip,vend_country)
- VALUES ('JTS01' ,'Jouets et ours' ,'1 Rue Amusement' ,'Paris' , NULL ,'45678' , 'France' );
- --------------------------
- - 填充产品表
- --------------------------
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- VALUES ('BR01' , 'BRS01' , '8英寸泰迪熊' ,5.99 英寸, 8英寸泰迪熊,带帽和外套' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- 价值('BR02' , 'BRS01' , '12英寸泰迪熊' ,8.99 英寸, '12英寸泰迪熊,帽子和外套' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- VALUES ('BR03' , 'BRS01' , '18英寸泰迪熊' ,11.99 英寸'18 英寸泰迪熊,帽子和外套' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- VALUES ('BNBG01' , 'DLL01' , '鱼豆袋玩具' ,3.49, '鱼豆袋玩具,带有用于喂食它的豆袋虫' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- 价值('BNBG02' , 'DLL01' , '鸟豆袋玩具' ,3.49, '鸟豆袋玩具,不包括鸡蛋' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- VALUES ('BNBG03' , 'DLL01' , '兔豆袋玩具' ,3.49, '兔豆袋玩具,自带豆袋胡萝卜' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- VALUES ('RGAN01' , 'DLL01' , 'Raggedy Ann' ,4.99, '18 英寸Raggedy Ann娃娃' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- VALUES ('RYL01' , 'FNG01' , 'King doll' ,9.49, '皇室服装和皇冠''12英寸王娃娃' );
- INSERT INTO Products(prod_id,vend_id,prod_name,prod_price,prod_desc)
- VALUES ('RYL02' , 'FNG01' , '皇后娃娃' ,9.49 ''皇后服装和冠'皇后' );
- ------------------------
- - 填充订单表
- ------------------------
- INSERT INTO 订单(order_num,order_date,cust_id)
- VALUES (20005,TO_DATE('2004-05-01' , 'yyyy-mm-dd' ), '1000000001' );
- INSERT INTO 订单(order_num,order_date,cust_id)
- VALUES (20006,TO_DATE('2004-01-12' , 'yyyy-mm-dd' ), '1000000003' );
- INSERT INTO 订单(order_num,order_date,cust_id)
- VALUES (20007,TO_DATE('2004-01-30' , 'yyyy-mm-dd' ), '1000000004' );
- INSERT INTO 订单(order_num,order_date,cust_id)
- VALUES (20008,TO_DATE('2004-02-03' , 'yyyy-mm-dd' ), '1000000005' );
- INSERT INTO 订单(order_num,order_date,cust_id)
- VALUES (20009,TO_DATE('2004-02-08' , 'yyyy-mm-dd' ), '1000000001' );
- ----------------------------
- - 填充OrderItems表
- ----------------------------
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20005,1, 'BR01' ,100,5.49);
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20005,2, 'BR03' ,100,10.99 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20006,1, 'BR01' ,20,5.99);
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20006,2, 'BR02' ,10,8.99 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20006,3, 'BR03' ,10,11.99);
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20007,1, 'BR03' ,50,11.49);
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20007,2 , 'BNBG01' ,100,2.99 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20007,3 , 'BNBG02' ,100,2.99 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20007,4 , 'BNBG03' ,100,2.99 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20007,5 , 'RGAN01' ,50,4.49 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20008,1 , 'RGAN01' ,5,4.99 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20008,2, 'BR03' ,5,11.99);
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20008,3 , 'BNBG01' ,10,3.49 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20008,4 , 'BNBG02' ,10,3.49 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20008,5 , 'BNBG03' ,10,3.49 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20009,1 , 'BNBG01' ,250,2.49 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20009,2 , 'BNBG02' ,250,2.49 );
- INSERT INTO OrderItems(order_num,order_item,prod_id,quantity,item_price)
- VALUES (20009,3 , 'BNBG03' ,250,2.49 );
运行脚本后:
之后简单查询下:
- SELECT prod_name
- FROM 产品;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~ THE END ------------------------------------------ ---------------------------------------