Oracle
zhutou0622
萨达萨达萨达萨达
展开
-
Oracle数据库学习-Day1
1.C:\Documents andSettings\Administrator>sqlplus /nolog--运行sqlplus命令,进入sqlplus环境,nolog参数表示不登录;2.SQL> conn /as sysdba--以系统管理员(sysdba)的身份连接数据库3.SQL> create user benjamin identified by pass;--创建...原创 2018-06-30 16:59:51 · 132 阅读 · 0 评论 -
Oracle数据库学习-Day2
1.创建表CREATE TABLE TBL_BOOK(ID INT NOT NULL,TITLE VARCHAR2(100) NOT NULL,AUTHER VARCHAR2(20),PRICE NUMBER);2.插入项INSERT INTO TBL_BOOK VALUES(1,’thurder,‘java’,200);INSERT INTO TBL_BOOK VALUES(1,’kitble’...原创 2018-06-30 17:09:01 · 137 阅读 · 0 评论 -
Oracle数据库学习-Day3
1.查询的嵌套select * from (select loginname,password from(select id ,loginname, password ,name fromIWEB_TBL_USER t where name like '%张%'))where loginname= 'zhangyin'; (由内到外。)有序的查询:select * from tbi_user o...原创 2018-07-01 20:32:36 · 197 阅读 · 0 评论