oracle学习
ztbsuper
这个作者很懒,什么都没留下…
展开
-
获取oracle的建表DLL语句
get_ddl('TABLE','表名','实例名') from dual[code="sql"]select dbms_metadata.get_ddl('TABLE','RMS_CITY','RMS') from dual[/code]结果[code="sql"] CREATE TABLE "RMS"."RMS_CITY" ( "INT_...原创 2010-07-07 18:40:57 · 315 阅读 · 0 评论 -
Oracle补完计划
虚拟表:dual查询结构: desc XXOOXOX[color=red][size=x-large]1.数据类型[/size][/color]查看Oracle的环境配置,比如字符集[code="sql"]select * from v$nls_parameters;[/code]varchar2 变长字符型,maxlength=4000b=2000个汉字nvarc...2009-09-03 10:46:55 · 112 阅读 · 0 评论 -
oracle col与set
[code="sql"]SQL> set timing on; //设置显示“已用时间:XXXX”SQL> set autotrace on-; //设置允许对执行的sql进行分析SQL> set trimout on; //去除标准输出每行的拖尾空格,缺省为offSQL> set trimspool on; //去除重定向(spool)输出每行的拖尾空格,缺省...原创 2010-05-17 11:00:24 · 196 阅读 · 0 评论 -
oracle锁
查看锁[code="sql"]select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time[/code]解除锁[code="sql"]alter system k...原创 2010-05-24 11:56:43 · 111 阅读 · 0 评论 -
没id的重复删除
[code="sql"]delete from ROUND_NAME_TEMP Awhere a.rowid ( select max(b.rowid) from ROUND_NAME_TEMP B where b.round_name=a.round_name and b.ems_name=a.ems_name)[/code]原创 2010-05-24 14:20:11 · 102 阅读 · 0 评论