CodeAutonetics

Delete Query : Query to delete from one table select from two table OR Delete using Join or ROWID Concept We come across scenarios where we have required filter condition based on join/Inner Query of two or more tables ,Here there are multiple ways to achieve the goal. 1)Use Primary/Unique ID Column  DELETE FROM table1 t1       WHERE t1.unique_column IN (SELECT t11.unique_column                                    FROM table1 t11, table2 t2                                   WHERE t11.unique_column.t2.unique_colum); 2)Use Rowid to delete DELETE FROM table1 t1       WHERE t1.rowid IN (SELECT t11.rowid                                    FROM table1 t11, tabl...

Table name :FND_CONCURRENT_REQUESTS Column name: PHASE_CODE Value  Meaning  C Completed  I  Inactive  P  Pending  R  Running Table name :FND_CONCURRENT_REQUESTS Column name: STATUS_CODE Value  Meaning  D  Cancelled  U  Disabled  E  Error  M  No Manager  R  Normal  I  Normal  C  Normal  H  On Hold  W  Paused  B  Resuming  P  Scheduled  Q  Standby  S  Suspended  X  Terminated  T  Te...

a)Query to get executable_name ,execution_method_code from concurrent program name SELECT fcpt.user_concurrent_program_name,        fcp.concurrent_program_name,        fe.execution_file_name,        DECODE (fe.execution_method_code,                  'A', 'Spawned',                  'B', 'Request Set Stage Function',                  'E', 'Perl Concurrent Program',                  'H', 'Host',                  'I', 'PL/SQL Stored Procedure',                  'J', 'Java Stored Procedure',                  'K', 'Java Concurrent Program',                  'L', 'SQ...