-
编辑 删除
alter session set nls_language nls_date_language
alter session, nls_language, nls_date_language, AMERICAN, SIMPLIFIED CHINESE[@more@]-- set languagealter session set nls_language ='AMERICAN';alter session set nls_language = 'SIMPLIFIED CHINESE';-- set date languagealter session set nls_date_language='AMERICAN';alter session set nls_date_language='SIMPLIFIED CHINESE';-- view session nls_languageselect USERENV('LANG') from DUAL;-- view session nls_date_languageselect SYS_CONTEXT('USERENV','NLS_DATE_LANGUAGE') nls_date_language from DUAL;
-
编辑 删除
Oracle删除锁表的进程
查看Oracle数据库被锁住的表，删除锁表的进程[@more@]查看Oracle数据库被锁住的表，删除锁表的进程 --1.查看被锁住的表SELECT dob.object_name table_name, lo.locked_mode, lo.session_id, vss.serial#, vss.action action, vss.osuser osuser, vss.logon_time, vss.process ap_pid, vps.spid db_pid FROM v$locked_object lo, dba_objects d
-
编辑 删除
EBS 11i Can’t see Move Orders Created by other users
Can’t see Move Orders Created by other usersEBS 11i Inventory Move Order Created By[@more@]ref Metalink : 280131.1A. Define the INV_INVTOMAI_CREATOR function if is does not already exist:Navigate: System Administrator > Application > FunctionEnter Function Name: INV_INVTOMAI_CREATOREnter User Function Name: ‘Move Orders Creator’Under the Properties tab, enter Type: SubfunctionEnter Maintenance Mode support: NoneEnter Context Dependence: ResponsibilitySaveB. Assign the functio
