欢迎来到天天文库
浏览记录
ID:22872402
大小:74.50 KB
页数:9页
时间:2018-11-01
《oracle增删改查语句》由会员上传分享,免费在线阅读,更多相关内容在工程资料-天天文库。
1、★oracle增删改查语句oracle基本语法(增删改查)安装PL/SQLDeveloper前提:必须安装Oracle的客户端卸载:------------------------------mandMC-----------------------------000000D5.0000.000211111111000000D5.0001.000211121111000000D5.0002.000211131111000000D5.0003.000211141111000000D5.0004.000211111111000000D5.0005.000211121
2、111000000D5.0006.000211131111000000D5.0007.000211141111查询到8记录。查出重复记录SQL》selectro,mcfromaax(roab=b.bmanda.mc=b.mc);ROMC------------------------------------------000000D5.0000.000211111111000000D5.0001.000211121111000000D5.0002.000211131111000000D5.0003.000211141111删除重复记录SQL》deletefrom
3、aaax(roab=b.bmanda.mc=b.mc);删除4个记录。SQL》selectro,mcfroma;ROMC------------------------------------------000000D5.0004.000211111111000000D5.0005.000211121111000000D5.0006.000211131111000000D5.0007.000211141111desctable;检查表结构select*fromtabtable;显示此表的数据行数;spoolc:tony.txt;日记路径spooloff;关闭记
4、录后可以看到日记文件里的内容。altertablestuadd(classidnumber(2));添加字段altertablestumodify(xmvarchar2(12));修改字段的长度altertablestudropcolumnsal;droptablestu;renamestudenttostu;altertablestudentdropcolumnsal;altertablestuadd(salarynumber(7,2));insertintostuvalues(‘A001’,‘张三’,‘男’,‘01-5月-05’,10);insertinto
5、stu(xh,xm,sex)values(‘A003’,‘JOHN’,‘女’);insertintostudent(xh,xm,sex,birthday)values(‘A004’,‘MARTIN’,‘男’,null);修改updateupdatestusetsex=‘女’stu;droptablestudent;deletefromstustu;select*fromstudentstudentstudentstudentstudentstudentorderbybirthday;select*fromstudentorderbybirthdaydesc,xh
6、asc;--按birthday降序按xh升序(asc/默认)select*fromstudentstudentstudentavgselectsysdatefromdual;dual哑元素没有表需要查询的时候selectxm
7、
8、‘-----’
9、
10、classidfromstu;select1+1fromdual;selectjob,next_date,next_sec,failures,brokenfromuser_jobs;shoeterjob_queue_processes;altersystemsetjob_queue_processes=5;selecto
11、efromdba_objectsdualgis3;判断是否创建篇三:Oracle增删改查常用操作表的增删改查创建表CREATETABLE[用户名.]表名(列名数据类型[default默认值][,...]...);SQL>createtablet1(2idnumber(10),3namevarchar2(20),4passempempber(10));SQL>desct1;名称是否为空?类型-------------------------------------------IDNUMBER(10)NAMEVARCHAR2(20)PASSBER(10)
12、SQL>alter
此文档下载收益归作者所有