2011年5月26日
oaf的lov属性错误
摘要： Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details. About Previous Page Error Page Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: ??? ?? ???? ?? at or. 阅读全文
posted @ 2011-05-26 20:43 郭振斌 阅读(1536) 评论(0) 推荐(0) 编辑
查看某个对象的锁
摘要： SELECT A.OWNER, A.OBJECT_NAME, B.XIDUSN, B.XIDSLOT, B.XIDSQN, B.SESSION_ID, B.ORACLE_USERNAME, B.OS_USER_NAME, B.PROCESS, B.LOCKED_MODE, C.MACHINE, C.STATUS, C.SERVER, C.SID, C.SERIAL#, C.PROGRAM FROM ALL_OBJECTS A, V$LOCKED_OBJECT B, SYS.GV_$SESSION CWHERE (A.OBJECT_ID = B.OBJECT_ID) AND (B.PROCESS 阅读全文
posted @ 2011-05-26 16:26 郭振斌 阅读(656) 评论(0) 推荐(0) 编辑
总结下Oracle 中的Insert用法
摘要： 1.标准Insert --单表单行插入语法:INSERT INTO table [(column1,column2,...)] VALUE (value1,value2,...)例子:insert into dep (dep_id,dep_name) values(1,'技术部');备注:使用标准语法只能插入一条数据,且只能在一张表中插入数据2, 无条件 Insert all --多表多行插入 语法:INSERT [ALL] [condition_insert_clause][insert_into_clause values_clause] (subquery) 示例:INS 阅读全文
posted @ 2011-05-26 13:29 郭振斌 阅读(133036) 评论(1) 推荐(0) 编辑