人丑多读书

SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;alter system kill session '239,284

http://scn.sap.com/community/businessobjects-dashboards/blog/2014/07/07/disabling-web-access-when-dashboard-designer-is-launched

大于值取整=CEILING(E18/POWER(10,LEN(E18)-1),1)*POWER(10,LEN(E18)-1)excel=TEXT(INT(C8/86400),"0天")&TEXT(TRUNC(MOD(C8,86400)/3600),"0小时")&TEXT(TRUNC(MOD(C8,3600)/60),"0分")&TEXT(TRUNC(MOD(C8,60)),"0秒")

SELECT   BASE_SCHEMA_NAME, BASE_OBJECT_NAME,               DEPENDENT_SCHEMA_NAME,DEPENDENT_OBJECT_NAME,               DEPENDENT_OBJECT_TYPEFROM     "SYS"."OBJECT_DEPENDENCIES"WHERE   BASE_SCHE

How to delete PACKAGE from HANA studio1.Unable to delete package from HANA studio2. While deleting from HANA studio it will showing inactive object present in package and refusing to d