zzz_781111的专栏

---TC_KH delete from TC_KH t where t.rowid > (select min(x.rowid) from TC_KH x where x.kh_id = t.kh_id  )  ;---TM_USERdelete from TM_USER t where t.rowid > (select min(x.rowid) from TM_USER x where

alter table tm_user add primary key (m_id);drop sequence a_sequence;create sequence a_sequencestart with 1increment by 1;create or replace trigger t_trgbefore insert or update on tm_userfor each rowbe

create or replace function myencrypt_str( p_str varchar2, p_key varchar2 default oracle) return varchar2 is v_str varchar2(16); v_str2 varchar2(32); v_txt_string varchar2(16); v_key varchar2(16) :=

SQL> select Customer_id from CUSTOMER_PUBLIC_INFO where  regexp_like(customer_id,BJBJ[^123456789]*1$);CUSTOMER_ID----------------------------------------BJBJ00000001oracle 数据库目前内建了符合posix 标准的正则表达式。