随笔分类 - 常见 SQL
摘要：在 msdb 下 select [dbo].[sysjobs].name,* from [msdb].[dbo].[sysjobhistory] inner join [dbo].[sysjobs] on [dbo].[sysjobhistory].job_id = [dbo].[sysjobs].
阅读全文
摘要：SET LINES 200 PAGES 200 COL OWNER FOR A10 WITH T1 AS (SELECT TO_CHAR(B.BEGIN_INTERVAL_TIME, 'YYYYMMDD') SNAPDATE, A.TS#, A.OBJ#, TRUNC(SUM(A.SPACE_ALL
阅读全文
摘要：先创建个触发器获取ip create or replace trigger on_logon_trigger after logon on database begin dbms_application_info.set_client_info(sys_context( 'userenv', 'ip
阅读全文
摘要：#### 查看某个用户下所有类型为视图的表名 ```select * from dba_tab_comments where owner='名字' and table_type='VIEW';``` #### 开启某用户下所有表的全列 ``` select 'alter table ' || OWN
阅读全文
摘要：#### 查看rman备份计划 ``` select * from dba_scheduler_jobs; desc DBA_SCHEDULER_JOB_RUN_DETAILS SELECT a.job_name, start_date, end_date, status FROM DBA_SCHE
阅读全文
摘要：[官网语法图](http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions199.htm) ``` TRIM([ { { LEADING | TRAILING | BOTH } [ trim_character ] | trim_c
阅读全文
摘要：### 查询堵塞会话 ``` select b.sid, b.serial#, b.username, a.event, c.sql_text, c.sql_id, b.machine, b.program from v$session_wait a, v$session b, v$sqlarea
阅读全文
摘要：##### 1. 查看表的主键 `EXEC sp_pkeys @table_name='表名' ` ##### 2. 获取一个表的列 ``` --2005 以上版本 select distinct(sc.colorder), sc.name, sc.xusertype, sc.length, sc.
阅读全文
