- 博客(4)
- 收藏
- 关注
RSS订阅原创 sql 驼峰
SELECTCOLUMN_NAME,CASEWHEN LOCATE(‘‘, COLUMN_NAME) = 0 THEN COLUMN_NAMEELSECONCAT(SUBSTR(COLUMN_NAME, 1, LOCATE(’’, COLUMN_NAME) - 1),UPPER(SUBSTR(COLUMN_NAME, LOCATE(‘‘, COLUMN_NAME) +1, 1)),SUBSTR(COLUMN_NAME, LOCATE(’’, COLUMN_NAME) +2))END AS
2022-05-23 15:58:32
258
1原创 游标法 批量修改多张表数据
游标法declarev_sql varchar2(1000);v_table_name varchar2(50);cursor c1 is select table_name from rwa1b_table_info where 条件 ;beginopen c1;loopfetch c1 into v_table_name;exit when c1%notfound;v_sql:=‘update’ || v_table_name || ’ set as_of_dt = to_date(
2020-10-16 17:37:08
257
原创 oracle 锁表查询 进程清除
SELECT SESS.SID, SESS.SERIAL#, MACHINE, LO.ORACLE_USERNAME, AO.OBJECT_NAME, LO.LOCKED_MODEFROM v$locked_object LO, dba_objects AO, v$session SESSWHERE AO.OBJECT_ID = LO.OBJECT_ID AND LO.SESSION_ID = SESS.SID;清除进程ALTER SYSTEM KILL SESSION '482,6
2020-10-16 17:23:27
146
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人