摘要:
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. 阅读全文
摘要:
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 阅读全文
摘要:
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 阅读全文