![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle的学习
Oracle知识点的学习
wangchango
I don't know the way to success,but I know the way to failure is trying please everyone.
展开
-
Oracle_3:DDL
DDL(Data Definition Language)数据定义语言create drop truncate alter一、create 创建表create table mytab1( id number, name varchar(10), age number);SQL> desc mytab1 名称 ...原创 2020-04-17 01:04:20 · 131 阅读 · 1 评论 -
Oracle_2:DML
DML(Data Manipulation Language)数据操纵语言insert delete update可以回退——可以进行事务操作SQL> set linesize 300;SQL> set pagesize 300;一、insertinsert into 表明(字段名1,字段名2,……) values(字段值1,字段值2,……)字段名和字段值一一对应:数据...原创 2020-04-17 01:03:53 · 119 阅读 · 0 评论 -
Oracle_1:入门
登录OracleC:\Users\往常>sqlplus scott/tiger--查看系统中有哪些表SQL> select * from tab;SQL> set linesize 300 --设置每行显示字符数SQL> select * from emp; EMPNO ENAME JOB ...原创 2020-04-16 02:00:36 · 607 阅读 · 0 评论