-
编辑 删除
rownum和rowid
在查询中，我们可以注意到，类似于“select xx from table where rownum < n”(n>1)这样的查询是有正确含义的，而“select xx from table where rownum = n”这样的查询只在n=1的时候成立，“select xx from table w...
-
编辑 删除
数据整合
create or replace procedure p_addhom isbegindeclare str_sql varchar2(3000); l_names province_py.pingying%type; cursor c is select pingying from province_py where sign=1 order by ...
-
编辑 删除
批量绑定
create or replace procedure p_postcode isbegindeclare type ridArray is table of rowid; type vcArray is table of NEW_jiangsu_1.youzhengbianma%type; l_rids ridArray; l_names vcArray...
-
编辑 删除
动态SQL
create or replace procedure p_ptable isbegindeclare str_sql varchar2(3000); l_names province_py.pingying%type; cursor c is select pingying from province_py order by pingying;&nbs...
-
编辑 删除
生成IP地址列表
create or replace procedure p_wxip asI_V1 int;I_V2 int;I_V3 int;I_V4 int;I_A1 int;I_A2 int;I_A3 int;I_A4 int;I_B1 int;I_B2 int;I_B3 int;I_B4 int;begin UPDATE TMP_WX SET F0=0; UPDATE ...
-
编辑 删除
Oracle行列转换
产品横向搜索需求：select vpa.* from v_product_attribute vpa where id=6 order by paid;苹果iPhone 4480 数码 网络类型 3G ...
