sql-oracle-doc

1. which constraint

select constraint_name,table_name,constraint_type,search_condition
     from user_constraints a 
     where a.constraint_name like `'%PK_MODE_STAR%'`

2. kill session

select saddr,sid,serial#,paddr,username,status 
    from v$session where machine = 'KelvinPC'  
-- kill session  
alter system kill session 'sid,serial#' ; 

3. all tables
   Oracle中查看所有表和字段

4. timestamp to date

SELECT TO_CHAR(1112070645000 / (1000 * 60 * 60 * 24) +  
       TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH:MI:SS') AS CDATE  
FROM PDA_ORDER t;