Oracle
mingde_he
这个作者很懒,什么都没留下…
展开
-
Oracle基本操作
1.字段描述无法显示cmd---regeditHKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0将NLS_LANG值改成SIMPLIFIED CHINESE_CHINA.ZHS32GB180302.SQL查询语句动态参数输入符号&name;3.将空值转化为0的函数: nvl(sum(t.apl_amount_n) ,0)into n_rmmc_ad原创 2009-12-17 15:38:00 · 442 阅读 · 0 评论 -
创建表空间和为用户以及为用户赋权限
create tablespace mypaydatafile /oradata/ora01.dbf size 2000M, /oradata/ora02.dbf size 2000M AUTOEXTEND OFF;create user mypayidentified by mypaydefault tablespace mypay;grant connec原创 2010-04-20 16:19:00 · 340 阅读 · 0 评论 -
row_number() over(order by col2 desc)用法
select *from (select t.*,row_number() over(partition by t.at_ab_id_n order by t.AT_SETTLE_DATE_D desc ) cn from mypay_account_settle t where t.at_ab_id_n=201001151300000002 and原创 2010-05-13 17:37:00 · 443 阅读 · 0 评论 -
从一个表中拿某列设置到另一个表中,通过外键关联。
update mypay_account_base set ab_ub_name_v = ( select ub_name_v from mypay_user_base where ab_ub_id_n=ub_id_n ) where exists ( select 1 from mypay_user_base where ab_ub_id_n=ub_id_n ) and ab_ub原创 2010-05-13 17:38:00 · 620 阅读 · 0 评论 -
ORACLE分页查询SQL语句
<br />select *<br /> from (select T1.*, rownum linenum<br /> from (select * from cod_mpos_order) T1<br /> where rownum <= 100) T2<br /> where linenum >= 90原创 2010-11-10 13:54:00 · 511 阅读 · 0 评论