Transaction Open Interface

-

 






Comments

Post a Comment

Popular posts from this blog

Oracle Lock table

-
 SELECT B.Owner, B.Object_Name, A.Oracle_Username, A.OS_User_Name   FROM V$Locked_Object A, All_Objects B WHERE A.Object_ID = B.Object_ID select * from V$Locked_Object select    c.owner,    c.object_name,    c.object_type,    b.sid,    b.serial#,    b.status,    b.osuser,    b.machine from    v$locked_object a ,    v$session b,    dba_objects c where    b.sid = a.session_id and    a.object_id = c.object_id;
Read more

Backup Command

-
  full database backup: ================================================= run { allocate channel c1 type disk; backup as backupset format '/u01/app/oracle/rman_bk/df_%d_%s_%p' incremental level 0 database; backup as backupset format '/u01/app/oracle/rman_bk/ar_%d_%s_%p' archivelog all delete input; } differential incremental database backup: ================================================= run { allocate channel c1 type disk; backup as backupset format '/u01/app/oracle/rman_bk/df_%d_%s_%p' incremental level 1 database; backup as backupset format '/u01/app/oracle/rman_bk/ar_%d_%s_%p' archivelog all delete input; } cumulative incremental database backup: ================================================= run { allocate channel c1 type disk; backup as backupset format '/u01/app/oracle/rman_bk/df_%d_%s_%p' incremental level 1 cumulative database; backup as backupset format '/u01/app/oracle/rman_bk/ar_%d_%s_%p' archivelog all delete input; } e...
Read more

Delete formula line

-
 select * FROM FM_MATL_DTL WHERE line_no=3 and RELEASE_TYPE='1'  and trunc(LAST_UPDATE_DATE)=trunc(sysdate) SELECT * FROM FM_MATL_DTL WHERE FORMULA_ID=(select FORMULA_ID FROM FM_FORM_MST WHERE FORMULA_NO='940589') AND RELEASE_TYPE='1' delete from FM_MATL_DTL WHERE FORMULALINE_ID='784760' and FORMULA_ID='65818' AND RELEASE_TYPE='1';
Read more