- 博客(4)
- 收藏
- 关注
原创 sql 驼峰
SELECT COLUMN_NAME, CASE WHEN LOCATE(‘‘, COLUMN_NAME) = 0 THEN COLUMN_NAME ELSE CONCAT( 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
216
原创 游标法 批量修改多张表数据
游标法 declare v_sql varchar2(1000); v_table_name varchar2(50); cursor c1 is select table_name from rwa1b_table_info where 条件 ; begin open c1; loop fetch 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
201
原创 oracle 锁表查询 进程清除
SELECT SESS.SID, SESS.SERIAL#, MACHINE, LO.ORACLE_USERNAME, AO.OBJECT_NAME, LO.LOCKED_MODE FROM v$locked_object LO, dba_objects AO, v$session SESS WHERE AO.OBJECT_ID = LO.OBJECT_ID AND LO.SESSION_ID = SESS.SID; 清除进程 ALTER SYSTEM KILL SESSION '482,6
2020-10-16 17:23:27
111
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人