项目常用语句

alter table NET_DIM_KPI_THRESHOLD modify (lower_limit NUMBER(10,2));
alter table ROLE_PRIVILEGE ADD  (module_state varchar2(4));


create table NET_DIM_WARN_LEVEL (
   LEVEL_ID             NUMBER(12)           not null,
   SEQ                  NUMBER(12)           not null,
   LEVEL_NAME           VARCHAR2(64),
   COLOR_MASK           VARCHAR2(64),
   REMARK               VARCHAR2(128),
   STATE                char(1),
   IMAGE_MASK           VARCHAR2(20),
   constraint PK_NET_DIM_WARN_LEVEL primary key (LEVEL_ID)
);

创建序列：
CREATE SEQUENCE SEQ_LEVEL_ID INCREMENT BY 1 START WITH 1 NOMAXVALUE NOCYCLE 
SELECT SEQ_LEVEL_ID.nextval from dual;


INSERT into dc_system_param(param_code,param_desc,param_val,create_date) VALUES('CHECK_CITY_DATA_NAME','查看全市数据权限','查看全市数据权限',sysdate);

INSERT INTO NET_DIM_KPI_THRESHOLD(kpi_id,level_id,net_type,upper_limit,lower_limit,create_date)
       VALUES(?,?,?,?,?,(select sysdate from dual));


UPDATE mm_data_privilege a SET a.module_state='02' WHERE a.privilege_id=2014623192 AND a.data_pkey_1 IN (998002160,998002161)

UPDATE NET_DIM_KPI_THRESHOLD SET level_id=1,Modify_Date=(select sysdate from dual) WHERE level_id=0 AND kpi_id=1;


SELECT a.* ,ROWID from dc_sql a WHERE dc_name='NET_TYPE';

SELECT * from dc_public t where t.stype = 2017061601;

SELECT TO_CHAR(upper_limit,'fm9999999990.00')upper_limit  from NET_DIM_KPI_THRESHOLD;

SELECT t.kpi_id kpi_id,t.kpi_code kpi_code,to_char(t.create_date,'yyyy-mm-dd hh24:mi:ss') create_date,t.kpi_unit kpi_unit
       FROM NET_DIM__KPI_SPEC t,NET_DIM_KPI_TYPE n 
       WHERE 1=1 AND t.kpi_type=n.kpi_type 
       
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;

select a.CODEB "START",a.CODEC end,a.PNAME label,a.CODEA color FROM dc_public a where a.stype=2000004 order by a.sortby 

select * from INDICT_SPEC where indict_name like '%账期%' escape '/' order by spec_id asc

SELECT * FROM PRIVILEGE_ACCR a WHERE a.accr_obj_id IN (1115110,138869,140867) AND a.privilege_id=2014623143;